Hi Team,
I hope you all are doing well!!
I am reading the below template in Alteryx
| Q1 2019 | Q2 2019 | Q3 2019 | Q4 2019 | Q1 2024 | Q2 2024 | Q3 2024 | Q4 2024 | Q1 2025 | Q2 2025 | Q3 2025 | Q4 2025 |
| 2 | 4 | 8 | 7 | 1 | 2 | 87 | 4 | 95 | 6 | 7 | 8 |
| 9 | 6 | 7 | 44 | 0 | 88 | 2 | 83 | 4 | 5 | 9 | 7 |
Based on the user selection of the year I would like to output only that particular year quarters along with all the previous year quarter in the output file.
For example if the user selects the year as 2024 while running the workflow then the output file should contain only this columns
| Q1 2019 | Q2 2019 | Q3 2019 | Q4 2019 | Q1 2024 | Q2 2024 | Q3 2024 | Q4 2024 |
| 2 | 4 | 8 | 7 | 1 | 2 | 87 | 4 |
| 9 | 6 | 7 | 44 | 0 | 88 | 2 | 83 |
Could you please help me on the same
Many Thanks in advance!!
Solved! Go to Solution.
@sneha_bhiwagade1
We can try with Dynamic Select tool by comparing the Year part with this year.

