Text to Column Help

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!

New Workflow3.yxmd

C1.XLS.xlsx

Help

Preparation

Accepted answers

Erin

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

New Workflow3.yxmd

All comments

Erin

Hi @nagajima,

Erin

New Workflow3.yxmd

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.

New Workflow3.yxzp

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703