Compare rows at aggregate level and flag

[Shaaz]

Hi All,

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

Below is the expected output.

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 ?

[Kakuffo]

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]

Hi @Shaaz, give this a try.

Thanks!

[Amol_Telore]

@Shaaz one more way of doing this.  

[Shaaz · Accepted solution]

Hi All,

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