Hi,
I am working on the request to pull out the information from 2 table based on the user inputs. The result to pull out from both the table have same column name, so I need the output in 1 single column.
So if table1 has column Region and Language whileTable2 has column Region and language also, then output should get result from both this column from both table in single result. Output should not contain Table1.Region, Table2.Region...
Output should contain only 1 column Region and should have values from Table1 and Table2 Region field.
I have achieved this using the Union All function, but it is not working properly with the Template.
Template is added, if the user does not provide any input for a specific field then during the run time that field won't be considered.
I have also attached a doc with the screenshot.
Please help me out or anyother way to achieve the same.
Thanks,
Nikhil Sanghvi
