Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Advanced Cross tab function and new columns creation

Highlighted
5 - Atom

Hi Everyone,

 

Does anyone know how to perform the following operation?

 

I would like to have as output the 3rd table, by creating new columns

 

1)Start Seller NameCity IDProductValue-€       
   Paul1A10       
   Paul1B5       
   Paul2C100       
   Paul2A20       
   John3D5       
              
2)What I managed to doSeller NameCity IDProduct A €Product B €Product C €Product D €     
   Paul110500     
   Paul22001000     
   John30005     
              
3)What I'd like to haveSeller NameCity ID #1Product A in city 1Product B in city 1Product C in city 1Product D in city 1City ID #2Product A in city 2Product B in city 2Product C in city 2Product D in city 2
   Paul11050022001000
   John3000500000
Highlighted
Alteryx Certified Partner

Hi @paolodinapoli 

See if it helps you ...
In fact it is a little different because the data from PAUL is in city 3 and not in city 1 according to your example.

Hugs

Labels