compare the EDW Amount and Bord Amt per Claim Number ?

[suvechha_b]

Hi All ,

I got a sample model attached . Please kindly assist me in doing a report like below description-

My requirement is - I have to compare the EDW Amount and Bord Amt per Claim Number for Import month '2019-01-01' for record_source_gm_id.

Say for example , 'Claim Number' - 1 has 'EDW Amount' as '1000' but 'Bord Amt' has '1100' for the sample 'Import Month' '2019-01-01' for record source ''

Do I have to create a key by joining 'Claim Number','Import Month' and 'record Source Gm Id' ?

Please also assist me in concat the three in the script ?

I am getting the result correct , but how to show the Record Source GM ID ?