Dynamic Selection of Columns

[sneha_bhiwagade1]

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!!

[Qiu · Accepted solution]

@sneha_bhiwagade1 
We can try with Dynamic Select tool by comparing the Year part with this year.