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

[KamenRider]

Thanks @binuacs 

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

[binuacs]

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

[KamenRider]

Thanks @binuacs 

Appreciate your help on this.

Kamen