Changing a Column Name based on it's location

Question

Hi, I'm trying to find a solution for changing a column name based on it's location.

In this example I have 3 columns in an input each month whose name changes based on the month.  It's a forecast for the next 3 months.

In August, the Columns were named September, October and November.  These 3 columns are always in the same location.

In order to not have to change the input file before adding it to Alteryx, I'd like to be able to have my workflow change it to Month 1, Month 2, and Month 3.

Is this possible?

markcurry · Answer

Hi @bdroberts77

See the attached workflow, I think this will give you what you're after.  I'm presuming that the data in your input file will be in the correct order.   Hope it helps.

Mark

Rename Month Columns.yxmd

AngelosPachis · Answer

Hi @bdroberts77 ,

You can use a dynamic rename tool to do that. I have created one sample file for August (containing Sep, Oct and Nov) and one for September (containing Oct, Nov and Dec) to prove the concept behind this workflow.

Hope that works for you.

Cheers,

Angelos

sample_workflow.yxmd