How when we have the list of the fields we can process the data
The first thing we need to do is to place a list of fields next to the data
Source File example
Desired Result
This can be easily done with keep value transformation function, plus we use Metadata function to get the source file name
Next step is to get rid of the first line of every file using validator + Is Equal Validation function
And the last step is to extract field values based on field name position
Feedback from the customer: Thanks for your help. Your solution was the only one to achieve this (tried all your competitors)
Direct link, no registration required.
