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

Compare rows at aggregate level and flag

Shaaz
9 - Comet

Hi All,

 

I've a input data like below and summarizing at ID,Code level.

Shaaz_0-1658835429210.png

 

Below is the expected output.

Shaaz_1-1658835490477.png

 

Logic here is

if at ID level, if we have 2 different codes then Mark them as Flag1

if at ID level, if code = 'AA' then Flag2

else Flag3

 

Can you please help me in achieving this ?

 

 

4 REPLIES 4
Kakuffo
Alteryx
Alteryx

Hi @Shaaz 

 

Would the flag increase in number based on the code appearing twice only would anything else cause the flag count to increase?

If not please see attached

grazitti_sapna
17 - Castor

Hi @Shaaz, give this a try.

grazitti_sapna_0-1658836676852.png

 

Thanks!

Sapna Gupta
Amol_Telore
11 - Bolide

@Shaaz one more way of doing this.  

Amol_Telore_0-1658836975054.png

 

Shaaz
9 - Comet

Hi All,

 

Thanks for the above solutions, but I figured out in a simple way.

Labels