I have two datasets. If a Customer Number exists in both, I want to tag the row that has the source "Sharepoint" for deletion. I am using the Multi Row Formula Tool, but I it is currently marking the wrong row for deletion. It is marking the 'Cat Rep" row instead of the "Sharepoint" row for deletion when the Customer Number is a duplicate. I have attached the workflow. What am I doing wrong? Any guidance would be greatly appreciated!
Solved! Go to Solution.
@RCern
I made some changes and hope it works for you now.
Since you want to flag the "Sharepoint" row, since the current row shall be "Sharepoint".
@Qiu Thank you so much!!!
Glad to help 😁