Hi,
I would like some assistance on creating an output file with fields in a specific order.
My input text file has all the Alphabetical fields shown in the "Desired Outcome" spreadsheet i.e. "A", "B", "C", "Y" and "Z".
However the text file always contains dynamic fields. For instance in the 2 fields "Field1_Y" and "Field1", the numerical elements can change every text file, so it could be "Field2_Y" and "Field2" or even "Field100_Y" and "Field100".
What I would like to achieve is to have fields "A", "B", "C" always appearing first in the output file. But then the dynamic fields i.e. Field1_Y appearing before Field1 but also appearing before fields "Y" and "Z".
Instead of having to manually select and reorder the fields every input file, I would like to set up a workflow where this is always calculated.
I have attached a desired outcome file. Any assistance on this would be well appreciated!
