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.
Find answers, ask questions, and share expertise about Alteryx Designer.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
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.