how to read mutiple CSV files with different Schema

[Anonymous]

I have 70 csv files with different schema my  job is to load all these files in one table with standard schema.

Please see the example below.

I have used tUnpivotRow component to transpose desired columns. But i have more than 70 csv files all of them with different schema. How can i simplify my job ?  

how can i use tFileList kind of component in my job? i'm using Talend open studio-7.1 version.

Thanks,

sri

[fdenis]

hi,
if you are on enterprise version you can use dynamic schema.
if not you can also read by row using schema col1 col2 col3 and all to the end into col4.

good luck