Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Finding duplicate record based on another field value within the group

jramidi
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
2 REPLIES 2
DavidP
17 - Castor
17 - Castor

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

 

DavidP_0-1585006359625.png

 

jramidi
6 - Meteoroid

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

Labels