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'm New to alteryx & to the community too. Here's my first question.
I have a single source of data where I need to compare today's data with yesterday and find the cases which are in yesterday and not in today's. ( It seems simple when I connect the same source twice and write one flow with today's date and other with today -1 and join and find missing).
But the request is to do the comparison from start of time in the data source say 1st Jan 2020 till date. Compare everyday data with prev day and finding the missing ID and have it stored to new output .
(like 2nd jan vs 1st jan , 3rd vs 2nd jan, 4th vs 3rd jan......... goes on. But have to exclude sunday and saturday. For monday data the comparison needs to happen with Friday data).
The 1st step is to convert [Date] to a valid Alteryx date format. You can then create a new field called [Previous day] with an if statement that subtracts 3 days if it's a Monday and 1 day otherwise. You can add conditions for Sundays and Saturdays here if you wish.
Now that you have the previous weekday, you can join you data using date and previous day. You can also add other join conditions here such as ID, etc.