How to manage Dynamic Files

[lcupito]

Hi everyone,

I have a problem with dynamic files. Each time they are loaded with extra columns (in random order and not at the end). How can I create a job where at the end it gives me the file with the original pattern?

E.g. the loaded file could be column1, column2, column6, column3, column7, column4, column5 and the schema should be

column1, column2, column3, column4, column5

Thank you

[Anonymous]

Hello,

I'd start by using dynamic schema then get the column value based on its name. Maybe these examples are helpful for it: https://jira.talendforge.org/browse/TDI-48091

[Anonymous]

Hi

Read the file using dynamic schema, and then extract the required fields using tExtractDynamicFields component.

Regards

Shong