Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Transformation

bh1789
8 - Asteroid

If I have one column with several divisions:

 

Division1.JPG

 

 

and I want to output like divisions into separate new columns:

Division2.JPG               

 

 

Thank you!

2 REPLIES 2
Emmanuel_G
13 - Pulsar

@bh1789 

 

Find in attachement one way of doing that.

 

Let me know if there is any trouble in the solution.

 

Emmanuel_G_0-1667727271443.png

 

bh1789
8 - Asteroid

Thank you Emmanuel_G for your assistance.  I should have shared the entire data column with you.  If you look at the screen shot of data below, most column entries need to be renamed from the name under Division to the name under Main Division.  However, line 17 and 18 need to be combined into the same column renamed to Greater South and lines 20 and 21 need to be combined into same column renamed California.  Can you assist?Main Division.JPG

Labels
Top Solution Authors