Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi
Read the file using dynamic schema, and then extract the required fields using tExtractDynamicFields component.
Regards
Shong