In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
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
Fall Release Webinar
Alteryx One Admin Experience
Labels
Top Solution Authors
View All