Splitting a single column specified with delimiter into multiple column

[BhumikaS]

Just started learning Alteryx two days back and finding a solution for:

How I can split one column into two, separated by (.) Dot?

Example:

Total Cost

132.22

143.55

34.12

The result should be:

Doller  Cent

132      22

143    55

34        12

How to separate Doller and cents in different columns?

[CharlieS · Accepted solution]

Use the Text to Columns tool found in the Parse Category.

https://help.alteryx.com/2018.2/TextToColumns.htm

[BhumikaS]

Thank you, this helped.