Hi,

right up front: I'm new to talend!

I have 3000 csv files that each consists of roughly 1000 rows, each row being identified by an ID. Several other variables are in those rows.
I would like to merge the files into one, so that each row contains the value to one ID from the different files:

ID variable1-file1 variable1-file2 variable1-file3 etc.

I tried using:

t_FileInputDelimited -> tUnite -> tAggregateRow

with the "list" function for the variable in tAggregateRow. It works, that the data is merged to each ID, but the problem is that the variables are not in order, but randomly listed.

Many thanks for any other ideas how to do this!

Cheers,
Tobi