Alteryx Designer Desktop Discussions

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

Grouping data set

sriku
7 - Meteor

Hi All,

 

I need to bucket each row as Yes or No.

 

If each  row fields are same or null then "No".

If each row fields are different then "Yes"

 

Thanks in advance.

 

4 REPLIES 4
danilang
19 - Altair
19 - Altair

hi @sriku

 

Here you go.  the key is to transpose and compare the values grouped by Account.  This allows to scale to any number of columns 

 

Solution.png

 

Dan

ponraj
13 - Pulsar

Here is the sample workflow for your case.  Hope this is helpful. 

 

WorkflowWorkflowResultsResults

sriku
7 - Meteor

Thanks Dan for your help.

 

Regards,

Sriku

sriku
7 - Meteor

Thanks Ponraj for your prompt response.

 

 

Regards,

Sriku

Labels