How to import a csv file with empty rows

[jonasheise]

Hi all!

I have a hard time finding out how to import .csv files who have the same layout but some empty columns in the beginning. The main problem is, that from the first 6 rows I only need the "Invoice no", "Invoice date" and "Customer no." These 3 should be headers of the first 3 columns where their value will be filled in.

Then the data from row 7 and down is the rest of my data and should be union together with the first 3 constructed columns.

I have added a .csv file (with dummy data) to visualise what I am trying explain above if it does not make sense. I have also uploaded my alteryx flow where I have tried to create it with just one .csv file due to I can't get the batch macro to work.

[jonasheise]

What about this one?

[DavidP · Accepted solution]

Ok, this now loads your latest file correctly.

[jonasheise]

Thank you so much!