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!!
@sneha_bhiwagade1
We can try with Dynamic Select tool by comparing the Year part with this year.