I have 2 files, need to merge them in format as in the expected excel file.
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.
@hf14 one way of doing this with the reporting tool
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
thanks @binu_acs
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"
@hf14 updated workflow attached
