Splitting a column into two different column in Alteryx.

[kiotsuresh]

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:

Category1	Category2
Home	Furniture
Home	Dining
Office	Printers
Office	Laptops
Library	Books
Library	Pens

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

[Reddy4]

1. Use Multi-Row Formula tool to create new field named Category1 of V_String datatype. In the Expression use this "IF Startswith([Category], ' ') = -1 THEN [Row-1:Category1] ELSE [Category] ENDIF"
2. Then use Filter Tool with expression "[Category] != [Category1]"
3. Then, use Data Cleansing tool to remove Leading and Trailing Whitespace
4. Finally, use Select tool to rename Category to Category2 and reorder the fields

[Parinita]

Hi kiotsuresh,

Please find the exact solution for your challenge attached in the file.

Please like and share if it helps solving your problem.

[grazitti_sapna]

Hello @kiotsuresh, try this.

I hope this helps!

Thanks!

[kiotsuresh]

I have Used a lookup table and Achieved the solution. Thanks Everyone!