Alteryx Designer Discussions

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

Splitting a column into two different column in Alteryx.

kiotsuresh
7 - Meteor

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
16 - Nebula

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
17 - Castor

@kiotsuresh One way of doing this

binuacs_0-1657037754615.png

 

kiotsuresh
7 - Meteor

I have Data like this,

 

Name

Suresh

     Kumar

Ram

     Rajesh

 

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

IraWatt
16 - Nebula

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

binuacs
17 - Castor

@kiotsuresh updated the workflow 

binuacs_0-1657039855817.png

 

kiotsuresh
7 - Meteor

Have Updated my Query

kiotsuresh
7 - Meteor

I have Updated the Post Sir.

IraWatt
16 - Nebula

Hey @kiotsuresh,

Heres one way to do that:

IraWatt_0-1657040165937.png

 

binuacs
17 - Castor

@kiotsuresh one way of doing this 

 

binuacs_0-1657048224551.png

 

 

Labels