Compare rows at aggregate level and flag

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 ?

Expression

Data Investigation

Accepted answers

Hi All,

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

Final_Solution.yxmd

All comments

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

SHaaz solution.yxmd

Hi @Shaaz, give this a try.

Thanks!

Shaaz_workflow.yxmd

@Shaaz one more way of doing this.

New Workflow3.yxmd

Hi All,

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

Final_Solution.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703