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.

Transform multiple row entries for same ID number into columns

gparks
6 - Meteoroid

I have a dataset that I am working on that for every ID number, there are multiple fields in the "Location" column, which creates repeats of the ID number in the dataset. I would rather have columns titled "Location_1","Location_2" etc so that there are all unique ID numbers in the rows. Any ideas on how to do this? 

1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @gparks 

 

Here is a workflow for the task.

Input:

atcodedog05_0-1603731006512.png

Output:

atcodedog05_1-1603731023563.png

Workflow:

atcodedog05_2-1603731046391.png

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Labels
Top Solution Authors