Removing entries from False Output Filter where ID is true Output

[Masond3]

Afternoon Team, 

Hope all is well. 

Looking for some assistance.

AIM : In the "False" output of a Filter, check and see if the ID in "IDA" column is in the "True" output.

• If the ID is Found in the "True" output then remove the record from the "False" Output
• If the ID is Not found in the "True" output then Do nothing (Ie dont remove record)

Example 

Input 1

First Name	Last Name	Company	IDA
Daniel	Johnson	Johnson & Co	111111

Input 2 

ID	First Name	Last Name	Company
999999	Daniel	Johnson	Johnson & Company - NYC
888888	Daniel	Johnson	Ferrari

I am performing a trim([First Name]+[Last Name]) and then joining onto another table . Which produces the following ;

ID	First Name	Last Name	Company	First Name	Last Name	Company	IDA
999999	Daniel	Johnson	Johnson & Company - NYC	Daniel	Johnson	Johnson & Co	111111
888888	Daniel	Johnson	Ferrari	Daniel	Johnson	Johnson & Co	111111

I am producing a "Reason" Column which is a formula to say ;  IIF(Contains([Company], [Company]), 'Contains', 'No Match')

ID	First Name	Last Name	Company	First Name	Last Name	Company	IDA	Reason
999999	Daniel	Johnson	Johnson & Company - NYC	Daniel	Johnson	Johnson & Co	111111	Contains
888888	Daniel	Johnson	Ferrari	Daniel	Johnson	Johnson & Co	111111	No Match

Regards
Masond3

[atcodedog05]

Hi @Masond3 

Here is how you can do it.

Workflow:

Hope this helps : )

[Masond3]

@atcodedog05  Thanks for responding, However that doesn't resolve my use case. If we look at the attached flow, my problem is when i apply a filter after the "If Formula". The reason why i need that filter, is because if that ID not found in the "True" Output then i need to continue with additional Logic, But i want to ensure that i am only processing records which are needed. ( ie not found in the "True Output")

[atcodedog05]

Hi @Masond3 

Try this with more sample data. Hope this meets the requirement.

Hope this helps : )