Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Dynamic Selection of Columns

sneha_bhiwagade1
8 - Asteroid

Hi Team,

 

I hope you all are doing well!!

 

I am reading the below template in Alteryx 

 

Q1 2019Q2 2019Q3 2019Q4 2019Q1 2024Q2 2024Q3 2024Q4 2024Q1 2025Q2 2025Q3 2025Q4 2025
24871287495678
967440882834597

 

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 2019Q2 2019Q3 2019Q4 2019Q1 2024Q2 2024Q3 2024Q4 2024
248712874
96744088283

 

Could you please help me on the same

 

Many Thanks in advance!!

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

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

1119-sneha_bhiwagade1.png

Labels
Top Solution Authors