How to refer to changing column name

Question

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!

binu_acs · Answer

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

Dynamic_Select_080223.yxmd

ShankerV · Answer

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

Changing column name.yxmd

bramvanbaalen · Answer

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