Splitting Data into Columns Using Delimiters in Alteryx

FYI.

录制_2025_04_23_14_18_01_588.gif

Mathias_Nielsen

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

2025-04-23_08-23-26.png

hi @flying008

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

Kamen

You can just do this like as @Mathias_Nielsen .

录制_2025_04_23_14_50_21_836.gif

Hi @flying008

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

Kamen

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

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

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

So, what is your real question?

binu_acs

@KamenRider

tab_dilimited_23042025.yxzp

Thanks @binu_acs

One last more, would you know how to remove the exponents? The output shows exponential form instead of the complete number. Tried using TOString using the formula but it doesn't work.

Please advise.

Kamen

binu_acs

@KamenRider the ID field is a v_string if it is still showing scientific notation can you adjust the excel type to number