Hello All,
I am a new user and need your assistance in solving an issue.
Below is a sample of my data. If any row with the same Batch ID has an Allocation rule = User provided i must delete all rows associated with that Batch ID.
There is no set amount rows associated with each Batch ID.
Batch ID | JE Index | Transaction Index | Allocation Rule |
200788 | 1 | 1 | Non-Dominant |
200788 | 2 | 1 | Non-Dominant |
200788 | 1 | 2 | User Provided |
200788 | 2 | 2 | User Provided |
203324 | 1 | 1 | Non-Dominant |
203324 | 1 | 2 | User Provided |
203337 | 1 | 1 | Non-Dominant |
203337 | 1 | 2 | By Units Held |
203485 | 1 | 1 | Non-Dominant |
203485 | 1 | 2 | By Units Held |
203719 | 1 | 2 | Non-Dominant |
203719 | 1 | 3 | Non-Dominant |
203719 | 1 | 1 | By Units Held |
Expected Result:
Batch ID | JE Index | Transaction Index | Allocation Rule |
203337 | 1 | 1 | Non-Dominant |
203337 | 1 | 2 | By Units Held |
203485 | 1 | 1 | Non-Dominant |
203485 | 1 | 2 | By Units Held |
203719 | 1 | 2 | Non-Dominant |
203719 | 1 | 3 | Non-Dominant |
203719 | 1 | 1 | By Units Held |
Thanks!
Solved! Go to Solution.
Thanks for the help!
Thanks for providing workflow. This worked out