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

SourceFile1

Desired Result

Step1

This can be easily done with keep value transformation function, plus we use Metadata function to get the source file name

Using Keep value transformation function

Next step is to get rid of the first line of every file using validator + Is Equal Validation functionRemoving first line using validator

And the last step is to extract field values based on field name position

Extracting Field Name

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.