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.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Complex transpose of data

batista_randy
6 - Meteoroid
‎12-19-2023 08:11 AM

I have this source data: 

 

Contact Name (Q3_1)Contact Email (Q2_1)Country of Entity (Q5)Country Company 1Country Company 2Country Company 3Country Company 4Country Company 5
Name 1Email 1Country A   XYZ 
Name 2Email 2Country B ABC   
Name 3Email 3Country C  ABC2  
Name 4Email 4Country C  XYZ2  

 

Is there a way I can transpose it to look like this? where the country Company matches the Country.

 

Contact Name (Q3_1)Name 1

Contact Name (Q3_1)

Name 2

Contact Name (Q3_1)

Name 3

Contact Name (Q3_1)

Name 4
Contact Email (Q2_1)Email 1Contact Email (Q2_1)Email 2Contact Email (Q2_1)Email 3Contact Email (Q2_1)Email 4
Country of Entity (Q5)Country ACountry of Entity (Q5)Country BCountry of Entity (Q5)Country CCountry of Entity (Q5)Country C
Country Company 4XYZCountry Company 2ABCCountry Company 3ABC2Country Company 3XYZ2
Labels:
Reply
0 Likes
1 REPLY 1
CoG
14 - Magnetar
‎12-19-2023 09:55 AM

Here is a sample workflow (the key is doing a double transpose:

Workflow.png

Sample Workflow.yxmd
Reply
GenAI Contest Form
License admin COmmunity Live
Labels
Top Solution Authors
View All