Generate list of dates
- 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
Hello All,
I'm trying to create an alteryx workflow which will generate values based on the dates mentioned in the existing column.
So I've few tests that has a activation and decommission date.
Now I've to add a column using alteryx which will generate the current dates.
so here are the conditions on which the values should be generated
Condition 1: If test 1 activation date 10/1/2019 and no decommission date. It should generate 6 months previous and future months like this (based on the current month like 11/24/2021)
5/1/2021 |
6/1/2021 |
7/1/2021 |
8/1/2021 |
9/1/2021 |
10/1/2021 |
11/1/2021 |
12/1/2021 |
1/1/2022 |
2/1/2022 |
3/1/2022 |
4/1/2022 |
Condition 2: If the activation date is 9/1/2021 and no decommission date. the new column should generate 6 months forward dates based on the current month and activation date
9/1/2021 |
10/1/2021 |
11/1/2021 |
12/1/2021 |
1/1/2022 |
2/1/2022 |
3/1/2022 |
4/1/2022 |
Condition 3: If the activation date is 10/1/2019 and decommission date is 12/1/2021. The dates should be like this
5/1/2021 |
6/1/2021 |
7/1/2021 |
8/1/2021 |
9/1/2021 |
10/1/2021 |
11/1/2021 |
12/1/2021 |
It should be 6 months previous to the activation date month and end till the decommission date.
All these data will be generated based on months and year. I've attached an excel sheet with expected input and output.
Also in the output I've highlighted the section that should not show up in the output.
Please let me know if we can achieve this using alteryx.
the current month will be generated using alteryx.
Regards,
Swapsingh2712
Solved! Go to Solution.
- Labels:
- Topic of Interest
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for the description of your challenge and apologies that I couldn't understand it perfectly first time around.
You will probably need to use a generate rows tool to generate additional rows which are in between a start and and end date.
There's a solution here which i think should be helpful: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Generate-Date-values/td-p/233
Please try to narrow down your request and I'll try to help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Joe_Lipski ! Let me lend you a macro ...
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.