In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

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
Top Solution Authors