Hello,
Appreciate if you can help me because I am trying to filter the previous month data from 1 whole year data.
For example, this November, I need to pull the data from October only from column C.
And for the next month once I run the Alteryx in Dec, I need to get the Nov data only.
Please help. Thank you in advance
PS:
Here's the sample data set - how about when I run it again for Nov data, I need to manually change the filter to 11.
What I am trying to achieve is once I run the Alteryx from the production it will automatically pick up the month I needed. T
Thank you so much!
Company Code | Year | Month | name 1 | name 2 | volume | volume2 | Year |
PPPP | 2022 | 01 | 1111111 | NAME1 | 10 | 1 | Oct-22 |
PPPP | 2022 | 02 | 2222222 | NAME2 | 2 | 3 | Oct-22 |
PPPP | 2022 | 10 | 3333333 | NAME3 | 3 | 2 | Oct-22 |
PPPP | 2022 | 03 | 4444444 | NAME4 | 626 | 1 | Oct-22 |
PPPP | 2022 | 05 | 5555555 | NAME5 | 326 | 1 | Oct-22 |
PPPP | 2022 | 10 | 6666666 | NAME6 | 62 | 561 | Oct-22 |
PPPP | 2022 | 10 | 7777777 | NAME7 | 5 | 1 | Oct-22 |
Solved! Go to Solution.
Do you have a complete dataset, a bit hard to see what the screenshot says.
However, it appears that column C is months, so you could extract some rows with a filter tool
[Month] = 10 for example.
Hi @gigi10
Yes, its possible.
Use the Formula tool or Date time tool to input the current date.
From the current date, you can derive the previous month.
Then use your existing workflow to do the necessary salutations,
Kindly accept this solution if it provided a solution to your question.
Many thanks
Shanker V
Here's the sample data set - how about when I run it again for Nov data, I need to manually change the filter to 11.
What I am trying to achieve is once I run the Alteryx from the production it will automatically pick up the month I needed. T
Thank you so much!
Company Code | Year | Month | name 1 | name 2 | volume | volume2 | Year |
PPPP | 2022 | 01 | 1111111 | NAME1 | 10 | 1 | Oct-22 |
PPPP | 2022 | 02 | 2222222 | NAME2 | 2 | 3 | Oct-22 |
PPPP | 2022 | 10 | 3333333 | NAME3 | 3 | 2 | Oct-22 |
PPPP | 2022 | 03 | 4444444 | NAME4 | 626 | 1 | Oct-22 |
PPPP | 2022 | 05 | 5555555 | NAME5 | 326 | 1 | Oct-22 |
PPPP | 2022 | 10 | 6666666 | NAME6 | 62 | 561 | Oct-22 |
PPPP | 2022 | 10 | 7777777 | NAME7 | 5 | 1 | Oct-22 |
Hi @gigi10
From my solution, you can attach the existing workflow when it will change the input as previous month.
As it will depend on the workflow. Have gave the best generic solution which will fit all type of workflows.
I need the workflow so I can recommend where it needs to be edited to get the best outcome.
Let me know if I could help further more.
Many thanks
Shanker V
Can I see your formula please? Thank you so much!