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

Need help with a workflow - Unsure of the functions to use

udles5666
8 - Asteroid

Hi Community,

 

Very new to Alteryx and need help with complex data set and need to get to a desired output. 

 

Attached is the workflow & screenshots of Input and desired Output.

 

Can someone please help me with this? I am lost and unsure what functionality I should use. 

 

Much appreciated. Thanks a ton in advance. 

 

INPUT

 

Crosstab Input.JPG

 

Desired OUTPUT

 

Desired_Output.JPG 

7 REPLIES 7
grazitti_sapna
17 - Castor

Hi @udles5666,

 

Can you please export the workflow. Not able to get the input data from your workflow.

 

Can you please go the options>export workflow.

 

 

Sapna Gupta
udles5666
8 - Asteroid

Apologies & here you go! 

Thanks

Drussek
9 - Comet

EntityId 724599 (from example) has two attributes with Right_Mandatory = 0.
Can you explain how it should work?

Drussek
9 - Comet

Maybe that's enough for you. The logic I asked about, maybe you can add it yourself

grazitti_sapna
17 - Castor

Hi @udles5666,

 

Here is my take on the problem. I hope it helps.

 

 

Sapna Gupta
udles5666
8 - Asteroid

Thanks @grazitti_sapna 

udles5666
8 - Asteroid

Thanks @Drussek ! 

That works. 

Labels