Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to read mutiple CSV files with different Schema

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.

0683p000009M5bM.png

 

Thanks,

sri

 

Labels (3)
1 Reply
fdenis
Master
Master

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