in my scenario, source 1 data will load on 1st of every month, where as my source 2 data will load after 5th of every month, this is applicable for all months, here iam validating the source 1 values(loaded on 1st of every month) with source 2 values by date wise like(source 1 date 1st and source 2 date 6th; source 1 date 1st and source 2 date 7th; source 1 date 1st and source 2 date 8th;....etc upto last date of the month). while validating the source 1 with source 2 values, i have to calculate count of match and no-match cases
In my previous question, source 1 and source 2 data loaded on same day. but here the load dates are different.
I am attaching the latest requirement case 1 spread sheet, please check once and help me how to create the summary dashboard.