Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Assigning a variable and transpose columns?

znooredeen004
7 - Meteor

Hi All,

 

My data is in the following format:

 

Client Name         Child's name            DOB

John Doe              Abe                          1/1/01

James Bond         Bob                           2/1/01  

Tom Cruise           Nick                          3/1/01

Tom Cruise           Sam                          4/1/01

Lisa Frank             Amy                          5/1/01

Lisa Frank             Pat                           6/1/01

Lisa Frank             Will                           7/1/01

 

I want to transform it so that the client name is only one line: For example Tom Cruises row would me

 

Client                         Child Name 1           DOB 1                Child Name 2          DOB 2

John Doe                   Abe                           1/1/01 

Tom Cruise                Nick                          3/1/01                 Sam                         4/1/01 

 

Is there a way to transform this?

2 REPLIES 2
Qiu
20 - Arcturus
20 - Arcturus

@znooredeen004 
Honestly, it is not that dynamic yet. Hope you get some ideas though.1020-znooredeen002.PNG

Qiu
20 - Arcturus
20 - Arcturus

@znooredeen004 
Thank you for marking it as accepted.

Labels