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.
Solved! Go to Solution.
Thank you so much!