The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

Alteryx Designer Desktop Discussions

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

Tranforming Data - Rows to Columns

Kristie_Pires
8 - Asteroid

Hello there,

 

How would you transform the data from the first table to the data on the second table? Whenever a loan has more than one guarantor, the guarantor name and ID should be displayed in another column. 

 

Loan ID Customer Name Guarantor NameGuarantor ID 
AMaryPeterxxxx-11
BJamesMayxxxx-12
BJames Laraxxxx-13
CAnnaRyanxxxx-14
CAnnaJohnxxxx-15
CAnnaChrisxxxx-16

 

Loan IDCustomer Name Guarantor Name 1Guarantor Name 2Guarantor Name 3Guarantor ID 1Guarantor ID 2Guarantor ID 3
AMaryPeter  xxxx-11  
BJamesMayLara xxxx-12xxxx-13 
CAnnaRyanJohnChrisxxxx-14xxxx-15xxxx-16
5 REPLIES 5
TimN
13 - Pulsar

TimN_0-1671407569062.png

 

TimN
13 - Pulsar

Here's a more complete one.

 

PanPP
Alteryx Alumni (Retired)

Hi @Kristie_Pires 

 

One way to accomplish this.

 

ArtApa
Alteryx
Alteryx

Hi @Kristie_Pires - Here is a dynamic solution for you:

ArtApa_0-1671408523822.png

 

Kristie_Pires
8 - Asteroid

Thank you all for helping me out! I always struggle with the Cross Tab and Transpose tool ðŸ˜…

Labels
Top Solution Authors