This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
Thanks for your effort, the attached workflow will pick up only the files based on quarter selection. But as per requirement it should compare the data between two quarters and write it in output . You can refer to the sample workflow. The workflow has to run three times if we are executing in third quarter.