Mid month Data Refresh
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
My table currently looks like this:
Roll | name | closed date cob |
1 | abc | 2021-03-05 |
2 | edf | 2021-03-09 |
This file is daily file that take previous day's data and keeps adding new closed name records along with cob dates so if it was today's run cob date would be . How do I create a workflow such that my run on 2nd day(cob 1st) or 17th day(cob 16th) of the month alteryx REMOVES all the previous days data in the input file ie from 16th to 30th closed date cob records on the second days month run and data of cob 1st to 15th on 17th day month run. Is this possible?
Also it should only include working days - Sunday's and Saturdays are excluded.
Please help
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @clarrock ,
you could use two Filter tools and DateTime functions to solve the problem. First Filter tool could cover the condition "1st to 15th" or "16th to last",
the second Filter should remove weekend days.
Let me know if it works for you.
Best,
Roland
