topic Re: Input column order in Talend Studio

Input column order

Anonymous — Sun, 05 Jul 2020 11:57:30 GMT

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.

Re: Input column order

Anonymous — Wed, 15 Jul 2020 04:57:25 GMT

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

Re: Input column order

vikramk — Thu, 16 Jul 2020 14:11:46 GMT

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