Remove rows based on condition

[ah108]

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!

[Luke_C]

@ah108 

Here's one way with a filter + Join

[Qiu · Accepted solution]

@ah108 
Basically similar with @Luke_C , just add one unique tool to make sure.

[ah108]

Thanks for the help!

[ah108]

Thanks for providing workflow. This worked out