Text to Column Help

[nagajima]

I'm trying to create a workflow that merges multiple files all in the same delimited format as the attached. 

First, I need to break out the files by delimiter. 

This can be done in Excel by simply using the text to column function on column A and then specifying "|" as the delimiter. 

When I try using the text to column function in Alteryx it doesn't break out all of the column headings. 

Any help would be greatly appreciated! 

Thanks! 

[Erin · Accepted solution]

Hi @nagajima,

Are the first 12 rows header info? Take a look at the attached which takes header names from row 13. Assuming row 13 is the headers for the data, this workflow also assumes that the number of columns would not change. 

Erin 

[Qiu]

@nagajima 
Somehow it works on my end.

And as @Erin mentioend, if your data start from Row#14, then we can use a Dynamic Rename to bring up the column names.

[nagajima]

This is perfect!! Thanks so much!

Row 13 is the correct header row and will always be static. I was trying to get rid of the first 12 rows by using the "Start Data Import on Line" of the input block. Maybe that's what it wasn't working for me.

Thanks again!