Concat comparing

[ntudev]

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?

PICID	AccoutNumber	Concat_Coding	Different?
91518248	7067912	CLEAN,TERM	Yes
91518248	7149046	AMORTZ,CLEAN,TERM	Yes
91588248	9067912	CLEAN,TERM	No
91588248	9149046	CLEAN,TERM	No

[FinnCharlton · Accepted solution]

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!