Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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