Input column order

[Anonymous]

Hello, 

I am trying to read a csv file for which i have created a metadata, but the order of columns is different, so Talend returns an error.

Is there a way to ignore the order and read the file based on the header names not order.

Thank you for your help.

[Anonymous]

Hello,

Here is a dynamic feature in talend. It allows you to design schema with an unknown column structure (unknown name and number of columns).

Please refer to this community knowledge article:

https://community.talend.com/s/article/How-to-process-changing-data-structure-ExK7j

Let us know if it is what you are looking for.

Best regards

Sabrina

[vikramk]

Talend has dynamic schema option for excel and csv files you can utilize it. For same drag a file input component depending on your file type and click on edit schema, in schema add a column and select the data type as Dynamic and connect the input component to your target.

By using this process you can insert the data without depending on column order