Reconciliation

[Bhagira]

Hi, I have two datasets. The first is Book_data, which contains the fields: PAN, amount, and invoice_date. The second is 26AS_data, which contains the same fields, plus one additional field: 26AS_id.

I want to match the records based on PAN. In Book_data, there can be multiple lines with amounts that, when totaled, match a single line in 26AS_data.

After matching, I want to update the matching records in Book_data by assigning the corresponding 26AS_id from 26AS_data.

Matching type is

One-to-one

One-to-many

Many-to-one

Many-to-many

[caltang]

Do you have sample data?

Also, what you have done so far? Show us and we will guide you. 

[Bhagira]

Please check the below sample data

[caltang]

@Bhagira thanks for providing the data, can you show us a sample scenario and sample output to replicate said logic?