Using if and extract to compare two fields from two files

[dennysthemenace]

In the below rule, I want to extract the records that are not in the DB. I am comparing the partner ID with Agency ID and extracting the records. If they are equal, I get the correct result.

=IF(PartnerId:.B =TRIMLEFT(TRIMRIGHT(DB_AGENCY_ID Field:.:test)),f_make_Agent_config(RECORD:test))

If I test for the negative condition, I get into a loop and produce multiple records.

=IF(PartnerId:.B !=TRIMLEFT(TRIMRIGHT(DB_AGENCY_ID Field:.:test)),f_make_Agent_config(RECORD:test))

I tried EXTRACT, but with a different result. I get the input as the output for negative conditions. Is there a way to use extract or any other functions to filter the records and get the records that are in the DB? Any help is appreciated. Thanks.

 

[eyetry]

=IF(PartnerId:.B !=TRIMLEFT(TRIMRIGHT(DB_AGENCY_ID Field:.:test)),none,f_make_Agent_config(RECORD:test))