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
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
