Read first row without header in union

[hf14]

I have 2 files, need to merge them in format as in the expected excel file. 

[binuacs]

@hf14 one way of doing this with the reporting tool

[Krzysiek]

Hey

Another way is by using Union Tool, to do so:

1) You need to set up Input Data Tool to "First Row Contains Data" as in the Screen 1

2) Then set up Union Tool to "Auto Config by Position" - Screen 2;

Order of Inputs to Union Tool are #1 Date, #2 Table 

Finally, you can see how the workflow looks like - Screen 3 

(Attached is workflow for your use as well)

Screen 1

Screen 2

Screen 3

[hf14]

thanks @binuacs  

This works but i want the output in excel format with filename appended by the date as this is a part of a daily activity and with a particular sheet name for example "HDI" as sheetname and filename as "HDI template 03.13.24"

[binuacs]

@hf14 updated workflow attached

[Krzysiek · Accepted solution]

Hey again!

Adding some adjustments to my workflow as well.

There is top lane which will serve as dynamic input for your file name:

1) I formatted the date to string and expected format;

2) Function Tool defines file name;

3) some selection to make the file clean;

4) Join Tool & setting change for Output Data Tool to take the File Name from Field and not to keep the Field in Output to keep your final Table neat.