Dynamic Selection of Columns

[sneha_bhiwagade1]

Hi Team,

I hope you all are doing well!!

I am reading the below template in Alteryx 

Q1 2024	Q2 2024	Q3 2024	Q4 2024	Q1 2025	Q2 2025	Q3 2025	Q4 2025
1	2	87	4	95	6	7	8
0	88	2	83	4	5	9	7

Based on user selection of the year I would like to output only that particular  year quarters 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 2024	Q2 2024	Q3 2024	Q4 2024
1	2	87	4
0	88	2	83

Could you please help me on the same

Many Thanks in advance!!

[flying008]

Hi, @sneha_bhiwagade1 

Even you use App or WF, you can use the Dynamic Select tool to filter the Fields as your want year, the Expression like

Right([Name], 4) = '2024'

[OTrieger]

@sneha_bhiwagade1 

You can achieve it with the Dynamic Rename and Dynamic select tool

Connect the data to Field Info tool, then append the year selection to the data, With formula tool Create a Column name Description. Set a formula for this field that says Need if the year is part of the field name, then connect this with a Rename Tool to the rest of the data. Select the Option Take Field Description from Right Input Row. Connect to it the Dynamic Select tool. Select Formula and then set [Description]="Need".
Now the Alteryx will keep only the needed headers and will remove all the rest.

[binuacs · Accepted solution]

@sneha_bhiwagade1 Analytic app approach

[sneha_bhiwagade1]

@binuacs Thanks for the solution 

[sneha_bhiwagade1]

@binuacs thanks for the solution 

just to add on after selecting the year from the drop down based on that I would like to also output all the previous year.

example if i select 2025 then 2024 data should also be in the output file

[binuacs · Accepted solution]

@sneha_bhiwagade1 updated workflow attached

[sneha_bhiwagade1]

@binuacs Thanks for the solution