Data Reconciliation

[prpanw]

I want to match one to one and one to many for examle  below bassis on policy, insured, Remit customer ID column i want those policy where netabs amount variance is 200$  but problem is same policy with insured and remit csutomer id has multiple line items

[jrlindem]

@prpanw can you provide more context and some example data/workflow?