Segregate column

[Aggsneh]

Hi,

I am using input file in csv format. I have two queries using alteryx as below.

1) There is a column for amount wherein it represents USD350.00 and I need to separate currency and amount.

2) Usage column represents this way 28.02.2020 04:44:32. I need to change this column in month format. For eg. Feb-20.

Can anyone help me out in solving both the above queries? It's little urgent.

Thanks

[JosephSerpis · Accepted solution]

Hi @Aggsneh I mocked up a workflow let me know what you think?

[jacob_kahn · Accepted solution]

@Aggsneh 

Please see my attached workflow for help 🙂 

Let me know if you need any other help!

[AlteryxUserFL]

This can be done with one formula tool, but to better help you understand what transformations are required, I did not use the formula tool. Hope this helps 🙂 

[Aggsneh]

Really helpful/ It worked.

Thanks

[Aggsneh]

Appreciate your help and quick response.