Splitting Data into Columns Using Delimiters in Alteryx

[KamenRider]

Hello Alteryx Community,

I'm currently working on a project where I need to split a single column of data into multiple columns using a delimiter in Alteryx. I think the data is structured with a pipe (|) delimiter (see below attached file), and I want to ensure that each piece of data is placed inside its own cell in the output CSV file.

Looking forward for your assistance on this inquiry.

Kamen

[flying008]

Hi, @KamenRider 

FYI.

[Mathias_Nielsen]

Hi, it is TAB delimited. You just tell the input tool that it is a CSV file. See the photo for configuration :)

[KamenRider]

hi @flying008 

Where did you get the Field1 in the formula tool? Can you share the worfklow?

Kamen

[flying008]

Hi, @KamenRider 

You can just do this like as @Mathias_Nielsen .

[KamenRider]

Hi @flying008 

What if I am using a directory tool? I am combining multiple files. How I am going to do it?

Kamen

[flying008]

Hi, @KamenRider 

You can use the path like 'C:\abc\123\*.txt' in Input tool.

[KamenRider]

Hi @flying008 

I do have the directory path and file specification configured. My dilemma is how to convert it to columns. Below is the workflow I created.

 

Please advise. Appreciate if you can share the workflow.

Thanks,

Kamen

[flying008]

Hi, @KamenRider 

In the options of Dynamic Input tool, you can set the Delimiters to 「|」or 「\t」as you want.

So, what is your real question?

[binuacs · Accepted solution]

@KamenRider