Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Finding duplicate record based on another field value within the group

Highlighted
6 - Meteoroid

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:

 

CustomerChangeDuplicate
ABCYN
ABC N
ABC---N
ABC N
ABC N
BCDYY
BCDYY
BCD Y
CDE Y
CDE---Y
DEF Y
DEFYY
DEF Y
DEFYY
DEF Y
EFGYN
FGH N
FGHYN
FGH---N
GHI N
GHIYN
HIJYN
HIJ---N
14 - Magnetar

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

 

DavidP_0-1585006359625.png

 

Highlighted
6 - Meteoroid

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

Labels