Text to Columns: Disaggregating data

[jf97hernandez]

Dear all,

I am sort of a noobie with Alteryx and was wondering if there is a simple way to use the Text To Columns plus RegExp to solve a probelm that I have.

I have in Column A account numbers, and in Column B Departments separated by ",". Is there a way to divide the departments by account? I was think something like /t /s in the Text to Column tool.

Thank you in advance for your time and cooperation.

Best,

jf97hernandez

[christine_assaad]

Hi @jf97hernandez 

Will you be able to provide data sample to better help you? Thanks!

[jf97hernandez]

Christine,

Thank you for your response. 

Here you go:

6282369	Air, Ocean, Ground
6281033	Air, Ocean
6281095	Air, Ground
6281096	Ocean, Ground

[Emil_Kos]

Hi @jf97hernandez,

you can use text to columns in order to create a new row. I don’t have access to alteryx now but if you will connect text to columns you will easily figure it out.

I found this pic in google it should help.

[Qiu · Accepted solution]

@jf97hernandez 

If you prefer RegEx and I also show the sample introduced by @Emil_Kos , need a Clean Tool though.

[jf97hernandez]

Thanks @Qiu !

You have been of great help! That is exactly what I wanted. 

So there was no need to use the RegExp > Text to Columns. Interesting.

Best,

Jf97hernandez