Concat comparing

Question

Hi Everyone.  Basically i need to group by PICID and then see if the Concat_Coding is different. if its different i need it to say its different in a new column. can this be done?

PICIDAccoutNumberConcat_CodingDifferent?915182487067912CLEAN,TERMYes915182487149046AMORTZ,CLEAN,TERMYes915882489067912CLEAN,TERMNo915882489149046CLEAN,TERMNo

FinnCharlton · Accepted Answer

Hi @ntudev , here is how to achieve this:

We group by PIC ID and count the number of distinct Concat_Coding values. If there is more than 1, we know to put 'Yes' in the Different column. Hope this helps!