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 |
