Removing entries from False Output Filter where ID is true Output

Question

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 NameLast Name CompanyIDADanielJohnsonJohnson & Co111111

Input 2

IDFirst NameLast Name Company999999DanielJohnsonJohnson & Company - NYC888888DanielJohnsonFerrari

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

IDFirst NameLast Name CompanyFirst NameLast Name CompanyIDA999999DanielJohnsonJohnson & Company - NYCDanielJohnsonJohnson & Co111111888888DanielJohnsonFerrari DanielJohnsonJohnson & Co111111

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

IDFirst NameLast Name CompanyFirst NameLast Name CompanyIDAReason 999999DanielJohnsonJohnson & Company - NYCDanielJohnsonJohnson & Co111111Contains888888DanielJohnsonFerrari DanielJohnsonJohnson & Co111111No Match

Regards
Masond3

atcodedog05 · Answer

Hi @Masond3

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

Hope this helps : )

match (1).yxmd

Masond3 · Answer

@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")

match.yxmd

atcodedog05 · Answer

Hi @Masond3

Here is how you can do it.

Workflow:

Hope this helps : )

match.yxmd