Hi Ballard, Thanks for your response. please find my below answers: 1) transaction_cdi_code variable is used to identify the credit transactions as C and debit transactions as D. customer is the party_number variable. 2) Let us consider the transactions of the Party_number A, it has 2 debit transactions(D) with the transaction_dttm of 20mar2020 and 13mar2020. it also has 2 credit transactions(C) with transaction_dttm of 19mar2020 and 12mar2020. now the code needs to compare the 1st debit transaction(D) of party_number A of 20mar2020 with the 2 credit transactions (C) with transaction_dttm 19mar2020 and 12mar2020. the output should be the pair of debit transaction(D) of 20mar2020 with credit transaction(C) of 19mar2020 because the look back period is 3 days and 19mar2020 falls within the 3 days period where as 12mar2020 doesnot fall within the 3 days lookback period. simillarly the 2nd debit transaction(D) of party number A of 13mar2020 has to be compared with the 2 credit transactions(C) with the transaction_dttm 19mar2020 and 12mar2020. the output should be the pair of debit transaction(D) of 13mar2020 with credit transaction(C) of 12mar2020 because the look back period is 3 days and 12mar2020 falls within the 3 days period where as 19mar2020 doesnot fall within the 3 days lookback period. here the pairing can be a flag variable or a counter variable to denote the matching. 3) now for the multpiles, let us consider the example of party number E. the party_number has 1 Debit transaction(D) as of 20mar2020 and 2 credit transactions (C) as of 19mar2020 and 18mar2020. here the debit transaction(D) of 20mar2020 has to be compared with credit transactions (C) of 19mar2020 and 18mar2020. now here both the credit transactions falls within the 3 days look back period. however we pair(flag) the first match of 19mar2020 and output the debit transaction(D) and credit transaction of 19mar2020 with a flag and also output the 18mar2020 without pairing or flag. the sample output for the party_number A and E is as below Party_number transaction_cdi_code transaction_dttm currency_amount transaction_key flag Matched_key A D 20MAR2020:00:00:00.000000 100.97 1234 Y 1234,1235 A C 19MAR2020:00:00:00.000000 101.97 1235 A D 13MAR2020:00:00:00.000000 100.97 1212 Y 1212,1213 A C 12MAR2020:00:00:00.000000 101.97 1213 E D 20MAR2020:00:00:00.000000 100.97 1238 Y 1238,1239,1231 E C 19MAR2020:00:00:00.000000 100.97 1239 E C 18MAR2020:00:00:00.000000 101.97 1231
... View more