Hi I will be creating 3 csv files everyday. These files have data that will be going in 3 different tabs of an existing xlsx file. Need help copying the data from each file to xlsx file tabs.
input_file#1 -- T:/documents/2022-08-08/file1.csv
# | date | name |
1 | 2022 | john |
input_file#2 -- T:/documents/2022-08-08/file2.csv
city | state |
nyc | new york |
input_file#3 -- T:/documents/2022-08-08/file3.csv
gender | age | height | weight |
m | 22 | 150 | 150 |
output file --> T:/documents/final_file.xlsx
sheet1 --> last row of input_file#1
sheet2 --> last row of input_file#2
sheet3 --> last row of input_file#2
Solved! Go to Solution.
hi @nkazi01
Bring each input in via an input tool followed by a sample tool configured for the last 1 record. Then you can output the files appropriately using the output tool.