Append the last rows from mutiple csv files to different tabs in one XLSX file

[nkazi01]

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

[Luke_C · Accepted 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.

[binuacs · Accepted solution]

@nkazi01 One way of doing this. As @Luke_C mentioned you need to use the sample tool for getting the last record of each file

[nkazi01]

thank you @binuacs and @Luke_C  for your solutions and suggestions.