Team, I am drawing a blank and struggling of a way to solve this AIM : To create a helper column that flags groups which have different reasons associated to them Input GroupReason839Exact First Name 839Cant Identify839Exact First Name 2Exact First Name, Exact Last Name, Exact Email2Exact First Name, Exact Last Name, Exact Email OutPut GroupReasonHelper839Exact First Name Y839Cant IdentifyY839Exact First Name Y2Exact First Name, Exact Last Name, Exact EmailN2Exact First Name, Exact Last Name, Exact EmailN Regards Masond3

Maybe now i understood your problem, try this version:

Screenshot 2023-08-30 083054.png

comma2.yxmd

All comments

Try this formula, it is basically counting "," and then assigning the label (the contains formula would work for your case too):

IF REGEX_CountMatches([Reason], ',') = 0 
THEN 'Y' 
ELSE 'N' 
ENDIF

comma.yxmd

Hi,

I dont think that would work as some of my reasons do have "commas" associated.

Any other potential solutions ?

Can you share some of the reasons that contains comma? Or even all possible reasons.

These are the current values i have for reason

Exact First Name, Exact Last Name, Exact Email

Exact L4, Different l5, Name with Nickname Reveresed First Name or Reveresed Last Name, Exact Email

Cant Identify

Name with Nickname Reveresed First Name or Reveresed Last Name, Exact Email

Exact L4, Different l5, Exact First Name, Exact Last Name, Exact Email

Exact L4, Exact l5,Exact Last Name, Exact Email

Exact L4, Exact l5, Exact First Name, Exact Last Name, Exact Email

Exact L4, Exact l5,Exact First Name, Exact Email

Exact L4, Different l5, First Name with NickName, Exact Last Name, Exact Email

Dummy

First Name with Nicknames, Exact Last Name

Exact L4, Exact l5, Name with Nickname Reveresed First Name or Reveresed Last Name, Exact Email

Name with Nickname First Name or Name with Nickname last Name, Exact Email

Exact L4, Exact l5, First Name with NickName, Exact Last Name, Exact Email

Exact L4, Exact l5, Exact Reveresed First Name or Reveresed Last Name, Exact Email

Exact Reveresed First Name or Reveresed Last Name, Exact Email

Exact L4, Different l5, Exact Reveresed First Name or Reveresed Last Name, Exact Email

Hey

I think i may of done it by using the Sumrasiation tool

Group by "Group"
Count Distinct by "Reason"

Then i can apply the following formula "if [CountDistinct_Reason] >1 THEN 'Y' ELSE 'N' ENDIF"

philipmannering

It doesn't look like any of these reasons have a comma in them. Think @Felipe_Ribeir0 's solution should work.

Maybe now i understood your problem, try this version:

Screenshot 2023-08-30 083054.png

comma2.yxmd

Thats the one.

Took me ages to work through it, but you gave me some ideas in your formula.

Huge thank you