Finding duplicate record based on another field value within the group

[jramidi]

Hello Alteryx Community Team,

I am trying to find duplicate record based on another field value within a group by using Multi-Row tool and running into issues.I appreciate any suggestions to solve this problem.

My requirement:

• If only one record “Change” field value is "Y" out of all records at “Customer” field group level then update “Delete” field value as “N” else update it as “Y” for all records within the same group.

Here I am attaching the sample workflow for your easy reference.

The expected output table data is as follows:

Customer	Change	Duplicate
ABC	Y	N
ABC		N
ABC	---	N
ABC		N
ABC		N
BCD	Y	Y
BCD	Y	Y
BCD		Y
CDE		Y
CDE	---	Y
DEF		Y
DEF	Y	Y
DEF		Y
DEF	Y	Y
DEF		Y
EFG	Y	N
FGH		N
FGH	Y	N
FGH	---	N
GHI		N
GHI	Y	N
HIJ	Y	N
HIJ	---	N

[DavidP · Accepted solution]

I wouldn't use multirow, I'd use summarize instead, like this:

[jramidi]

@DavidP - Thanks a lot for your quick response. This solution does work for my problem. Much appreciated!