VALIDATION of Two list on Alteryx

Question

Hello there gurus,

i need help comparing a requested update to the master file after the update to determine if the updates were done. Some requests add new records, and some delete existing records. I want to be able to return a file that tells me the request was done. please help see the sample excel. Record 1 is the request; record 2 is the sample master file after the update.

Record 1.xlsx

Record 2.xlsx

sulebraimah · Answer

they are new records to be added to the global records, the first one is mapped to a  parent company and the other one to a general ledger as depicted by the heading (internal char value)

binu_acs · Answer

@sulebraimah Can you also tell me why the two records are marked new? Also, are you comparing all the given fields of rows 1 and 2?

sulebraimah · Answer

you are right that records 1 and 2 are the same. i did that just to show an example of what i need help with. record 1 usually comes as a request to update some records on SAP, records 2 is usually the global record after the update. so my goal is to compare or match record 1 to record 2 to verify that the update was actually done. what i am looking to do is return an output that tell me the record 1 exists or does not exist in record 2. because the request for update is either a new record or deletion of an existing record