topic Re: How to manage Dynamic Files in Talend Studio

How to manage Dynamic Files

lcupito — Fri, 15 Nov 2024 21:21:34 GMT

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

Re: How to manage Dynamic Files

Anonymous — Mon, 09 Oct 2023 13:22:51 GMT

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

Re: How to manage Dynamic Files

Anonymous — Tue, 10 Oct 2023 03:12:40 GMT

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

Regards

Shong