Create & Extract Months in the Past 12 Months

[Kemuel]

Hi,

So I have a task to create a column containing month number in the past 12 months (from current execution date). But I find some difficulties to find the right node and maybe some logic behind it to create this list of months.

Maybe you can help me to solve this problem. Thanks in advance!

[bruno29a]

Hi @Kemuel , these 2 nodes will do:

Results:

Here are the instructions:
You just need to configure the Create Date&Time Range as follows:

1. Set the type to Date
2. Set number of rows to 12
3. Starting point, choose “Use execution date&time” which will use the current date
4. Set Interval to “-1M” meaning -1 Month per row

Then just extract the month number using the Extract Date&Time Fields, like this:

EDIT: Not sure which order you wanted it. If you are satisfied with the order above, then it’s all good.
But if you want it in the reverse order, you can add a Sorter node at the end, like this:

And sort on the Date column that was generated, in Ascending order:

The result will be in the reverse order of the above:

[Kemuel]

Hi,

Sorry for the late reply Bruno. Thanks a lot for your help, it really answer my question.

[bruno29a]

No problem @Kemuel , happy to help!