I have two files and I want to compare those two records ,after comparing I want to pull out the records which are same in both records and I want the new record from the unmatched records record format is like this: decimal(3) CUST_ID; string(6) CUST_NAME; string(" ") ADDRESS; same for two files; and my records are 01 sidhu hyd 02 phani bng 03 hasnu che 04 azeem vtm ...

Ahmad Ali Quraishi

• Jan 6th, 2024

1.Use one file as lookup file and another as input file.
2. Use Filter by expression component and we can use !lookup_match("Lookup1",cust_id") in FBE

Anand Kishore

• Oct 7th, 2022

Keep a file as lookup.
Use the syntax as lookup_match to get matching file and the rejected records are non matching record

Answer Question  Select Best Answer