loop files in a folder with join rather than concatenate
I have multiple .csv files which all of them in 1 folder such as table1.csv, table2.csv, table3.csv… this is just an example, more than 3 files in the the folder. They have the same ‘id’ but all of them have different column name.
I try to write a loop use the following node: list files/folder → table row to variable loop start → csv reader → loop end, but the loop end say execute failed: input table structure different from reference (first iteration) table. I think it is just using for concatenate the table.
How could I loop files in a folder with join rather than concatenate? (i.e. the desire output table that I want)
Table1 to 3 csv and the desire output is as following:
table1.csv:
table2.csv:
table3.csv:
the output that I want:
Thank you!!!