How to refer to changing column name

[bramvanbaalen]

How do I select a column thats always column 2 but changes in name for the month we're in? Example: in december the name of the column in the excel file would be DEC_EXAMPLECOLUMN, and in january it would be JAN_EXAMPLECOLUMN. How would I make sure that my Alteryx workflow can still select the column despite the first 3 characters changing every month (maybe through using a RIGHT command)? Any help would be greatly appreciated!

[ShankerV]

Hi @bramvanbaalen 

I will recommend this TIP/Trick to overcome the issue.

Many thanks

Shanker V

[bramvanbaalen]

Could you provide some more context of what I should fill in the dynamic renaming tool? havent used that before

[ShankerV]

Hi @bramvanbaalen 

Post all your calculation, you can rename the column dynamically.

Explaining in detail:

Step 1: Your Input file

Step 2:  My Text Input

I have used the Column1 

And column 2 name which will change as Changingcolumn

Step 3: When you use the dynamic rename tool, 

the column2 which ever it will be changed to Changingcolumn

So you can use those for all calculations, which will be common across the workflow.

Many thanks

Shanker V

[binuacs]

@bramvanbaalen One way of selecting the column name based on the current month name is with the help of the dynamic select tool