Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Discussions

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

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