how to read mutiple CSV files with different Schema

Anonymous — Sat, 16 Nov 2024 05:33:11 GMT

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

Re: how to read mutiple CSV files with different Schema

fdenis — Wed, 19 Jun 2019 08:04:33 GMT

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

topic how to read mutiple CSV files with different Schema in Talend Studio

how to read mutiple CSV files with different Schema

Re: how to read mutiple CSV files with different Schema