Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Splitting a column into two different column in Alteryx.

kiotsuresh
8 - Asteroid

I'm Having the Data as below,

Category
Home
     Furniture
     Dining
Office
     Printers
     Laptops
Library
     Books
     Pens

 

And So on...


I need to split this "Category" column into Two Columns "Category1"and  "Category2" .

Output:

 

Category1Category2
HomeFurniture
HomeDining
OfficePrinters
OfficeLaptops
LibraryBooks
LibraryPens

 

Can Somebody help on this please?. After splitting into two I need to left join both the output(which I'm aware).

13 REPLIES 13
IraWatt
17 - Castor
17 - Castor

Hey @kiotsuresh,

Cross tab is tool to go too when you want to make rows into column headers:

IraWatt_0-1657037626359.png

Any questions or issues please ask :)
HTH!
Ira

binuacs
20 - Arcturus

@kiotsuresh One way of doing this

binuacs_0-1657037754615.png

 

kiotsuresh
8 - Asteroid

I have Data like this,

 

Name

Suresh

     Kumar

Ram

     Rajesh

 

and so on. will this solution work in this case?

IraWatt
17 - Castor
17 - Castor

@kiotsuresh Does the extra spaces mean its a second name?

binuacs
20 - Arcturus

@kiotsuresh updated the workflow 

binuacs_0-1657039855817.png

 

kiotsuresh
8 - Asteroid

Have Updated my Query

kiotsuresh
8 - Asteroid

I have Updated the Post Sir.

IraWatt
17 - Castor
17 - Castor

Hey @kiotsuresh,

Heres one way to do that:

IraWatt_0-1657040165937.png

 

binuacs
20 - Arcturus

@kiotsuresh one way of doing this 

 

binuacs_0-1657048224551.png

 

 

Labels