Multiple CSV input files and data starts at different rows

Question

Hi guys!

I have multiple CSV files and I want to input all of it without using multiple input tool and in some file data starts in 3rd row and in some data starts from 4th row. How can I input all the data at 1 go and alteryx picks data from each file regardless data starting from 3rd or 4th .

Also I have an additional column in some data rest all fields are same .

Please suggest ways to achive it .

Regards

apathetichell · Answer

use "/0" as your delimiter in your input data.

use the wildcard.

Add a recordid.

filter out empty row. filter tool - !isempty([fieldname])

use a text to columns tool (in split to rows mode - use whatever your actual delimiter is to split)

now to finish:

use a tile tool. unique values. recordid.

use a cross tab tool with record id as your key column. use tile sequence number as your field headings and whatever your split up field form text to columns is your values. I put mine in concatenate mode.

use dynamic rename to replace your fake field headings with your real field headings (ie the first row of data).

Try that. One note - if you start getting your columns split wrong - that's because you have different numbers of delimiters in different rows...

martinding · Answer

Do the CSV files have the same schema? E.g. same number and order of fields?

If so, you can use 1 input tool and use a wild card (.*) in place of your file name, and after importing the files, simply use the Filter Tool to filter out the empty rows (e.g. row 1-2, row 1-3).