Hi,
I have a case that I cannot figure out. What I need is to place two different tables below each other. as seen on the picture both of them have different headers (marked in orange and yellow). How can I do it so they are position as on the screenshot below.
Appreciate your help.
ViTk0
Solved! Go to Solution.
Hi @vkulhany,
One of the ways is using the reporting tool. Taking into consideration that probably you want to make some fancy report I believe that might be the area that you should explore.
I have created a workflow for you:
The output:
To learn more about reporting tools I would advise to check the interactive lessons in the link below:
Hi @vkulhany
As @Emil_Kos mentioned the best way would be with the Reporting tools, but you can use the Union tool, but as the headers in the 2nd table will be strings, your data types will be strings. Using the union tool you will lose the headers from the 2nd table, so you would need to extract this information too. If there are more fields in the 2nd table than the first table, the resulting table will take the headers from the 2nd table. See attached....
Mark
Another option in addition to the reporting tools mentioned might be to output each table to a specific excel range in your output file. This would give you more control over formatting, but might be tricky depending on the volume of records.