Alteryx designer Discussions

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

Create new row for each data point but repeat ID number associated/ one to many

Highlighted
Meteoroid

Hi,

 

I am currently trying to do some data prep for salesforce upload. 

 

Input

 

Salesforce IDContact 1Contact 2Email 1Email 2
1TomRobsample1@a.com 
2Hannah sample2@a.comsample3@.com

 

 

 

Desired Output

Salesforce IDContact
1Tom
Rob
1sample1@a.com
2Hannah
2sample2@a.com
2sample3@a.com

 

 

Any help would be appreciated. 

 

Thanks

Highlighted
Alteryx Certified Partner

@ac5a

this can be done with the Transpose tool.

Group by the Salesforce ID field and transpose the rest of the fields.

Meteoroid

Brilliant. Thanks!

Labels