Reading multiple files, each has different number of rows to skip

[SM2]

The issue I am trying to solve is that each file sheet starts on different row. so I can't use the general input configuration or even the sample rows because my # rows to skip across all files is not universal. 

I think one way I can do it by creating a mapping file and defining the number of rows to skip for each file and joining it with the data and then applying the skipping rows based on the file name using a tool?

However, not sure if this applicable of if it is even possible to change the skipping rows based on file name. 

is there anyway to solve this issue?

[OllieClarke · Accepted solution]

Hi @SM2,

You could create a batch macro like this:

It reads in each file individually, filters to the headers (and therefore the data), renames the fields with the first row of data and then outputs.

If we just do a wildcard input, it looks like this:

If we use the batch macro it looks like this:

Let me know if that helps (workflow attached)

Ollie