Alteryx Designer Desktop Discussions

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

To change column name dynamically

Polite123
8 - Asteroid

Hi Team,

 

Need help on below topic.

 

I have a column named 'Final ' in the output of Alteryx workflow.

I would like to change the name Final to Q12022 dynamically with the help of calendar.

 

Input:

 

Final
2
3
4
5
6

 

Output using calendar if March 2022 is selected :

 

Q12022
2
3
4
5
6

 

Output using calendar if June 2022 is selected  and so on

 

Q22022
2
3
4
5
6

 

Thanks in advance

5 REPLIES 5
Felipe_Ribeir0
16 - Nebula

Hi @Polite123 

 

If you mean the app calendar, try the attached workflow

 

Felipe_Ribeir0_0-1673178786155.png

 

Polite123
8 - Asteroid

Hi @Felipe_Ribeir0 ,

 

Thanks for quick help.It worked.

 

What modification will be required in order to select previous quarter as well?

If we select March 2022,then the column name should be Dec 2021.

Your help is highly appreciated.

 

Thanks in advance

Felipe_Ribeir0
16 - Nebula

Hi @Polite123 

 

Try the attached workflow. 

 

 

Felipe_Ribeir0_0-1673180930431.png

 

Polite123
8 - Asteroid

Awesome.It worked.Thank you so much!!!

You saved my day!!!

Dr_Hammann_619
6 - Meteoroid

I have the same problem and this solution help me. Many thanks.

Labels