Generate list of dates based on the existing coulmn

[swapsingh2712]

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

[fmvizcaino]

Hey @swapsingh2712 ,

Here is an example for you.

Best,

Fernando Vizcaino

[swapsingh2712]

hello  @fmvizcaino 

Thank you for your response,I'm getting the attached error while using the generate rows tool

please advise

[swapsingh2712]

@fmvizcaino I believe it's because of the null vale, but I'm not sure how fix it.

[fmvizcaino]

Hey @swapsingh2712 ,

In my example, I included in the input dataset 2 additional columns named previous and after.

They have to be included somehow to create the additional dates, and they need to have values in them, meaning they can't be null or empty. The columns represent the range for months before and after.

Best,

Fernando Vizcaino

[fmvizcaino]

You can create these columns using conditions based on your business rules or a lookup table dated on the activation date.

[swapsingh2712]

@fmvizcaino  I've used the same conditions which you've used and included the "Previous" & "After" column, but still getting the same error.

Please find my workflow attached.

[fmvizcaino]

Hey @swapsingh2712 ,

Would you be able to share your dataset also?

Best,

Fernando Vizcaino

[swapsingh2712]

@fmvizcaino  Here's the dataset

[fmvizcaino]

Hey @swapsingh2712 ,

In order for this workflow to work, you need to create a lookup table with all the rules to previous and after months you need to create. For example, for 9/1 we need to add 6 months forward but 10/1, 6 months before and after. That should be a rule for a range of dates or something else.

Best,

Fernando Vizcaino