Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Help with CrossTab!!!

kkkim
8 - Asteroid

Hi, Alteryx Community:

 

I am looking to transpose the data to show as final state below: 

 

Currently, data is showing as below:

 

Original Status

Field 1Field 2Field 3Field 4
Aapplebananapeach
B123345678
Cabcdefghabcd
Dalteryxalteryxalteryx
Eapplebananapeach
F123345678
Gabcdefghabcd
Halteryxalteryxalteryx
I123345

678

 

I would like to transpose it to show below:

 

Ideal State:

ABCD
apple123abcdalteryx
banana345efghalteryx
peach678abcdalteryx
cherries111efghalteryx
avocado222efghalteryx

 

Thank you so much for your help!

 

4 REPLIES 4
Luke_C
17 - Castor
17 - Castor

Hi @kkkim 

 

Where do the 'cherries' and 'avacado' values come from? How do you determine which values to use? For example I see multiple apple values (A, E) as well as multiple '123' values in field 2 (B,F, I). Column I also seems to break the pattern of fruit - number - letter - alteryx. Is that correct?

kkkim
8 - Asteroid

The values should all be different! sorry for the confusion. it should be a straight transpose with column realignment. There should not be repeating values... Thank you!

Luke_C
17 - Castor
17 - Castor

Then just something like this then?

Luke_C_0-1657739737330.png

 

 

kkkim
8 - Asteroid

Yes! Thank you so much!

Labels