Hi All,
I have a business logic which will have data for each quarter. If am running the job on 2nd quarter then it should pick up second quarter file and first quarter files, find the difference in value by matching the key columns in both files and generate the output which contains two quarters data. Likewise in 3rd quarter the job should compare the data between first quarter and second quarter and as well 3rd quarter and 2nd quarter and genearte cumulative output. For the 4th quarter the job should do the same as we did in 3rd quarter and in addition it should compare the data between 4th quarter and 3rd quarter.
From my initial analysis, the above logic can be achieved through iterative macro, but am having confusion in creating iterative macro. Does anybody have any idea on achieving the above logic using iterative macro.
