Start Free Trial

Alteryx Designer Desktop Discussions

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

Not able to get the Desired Output as attached

8802036946
6 - Meteoroid

Need to have output as desired, from the input attached.

 

3 REPLIES 3
Shifty
12 - Quasar

Hey @8802036946 

You could try this:

 

Shifty_0-1682603658751.png

 

I've attached the packaged workflow that does the job.

 

binu_acs
21 - Polaris

@8802036946 One way of doing this

binuacs_0-1682603843045.png

 

cjaneczko
13 - Pulsar

The cross tab tool will get you there. I had to add a record ID to preserve the sort. 

 

cjaneczko_0-1682603905495.png

cjaneczko_1-1682603923101.png

 

Labels
Top Solution Authors