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:
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 |
Solved! Go to Solution.
@DavidP - Thanks a lot for your quick response. This solution does work for my problem. Much appreciated!