Automate Column name with File name

The answer is No. We need to use a method similar to @Peachyco approach reason being if we use formula mode there is no way to reference filename column value and get year from it. Refer the below.

As you can see above we cannot reference any column value in the dynamic rename formula mode. Hence we cannot create a column name with year in the name.

Hope this helps : )

atcodedog05

Hi @areeba

Here is how you can do it.

Workflow:

Hope this helps : )

YTD.yxmd

All comments

joslynzichawo

Hey @areeba, are you looking to set up a dynamic solution or to just create the new file name for these 2 instances?

areeba

Hi @joslynzichawo

The idea is to make sure that next year the number of the year is going to be updated in the column name

Column(Budget Year) with the Filename year (2020). column name should display as Budget Year 2020. This should automate every year when the filename year changes.

For ex: for next year it should be Budget Year 2021

Can you help?

joslynzichawo

Hi, I have two solutions here for you:

1. Use regex to pull out the year

2. Use our date time tool to pull the current year

Hope this helps

example.yxmd

Joss-workflow.yxmd

areeba

Hi @joslynzichawo ,

Thank you for the reply but this is not what i am looking for.

i want to add this year after my column name dynamically.

DawnDuong

hi @areeba

You can do this via 2 steps:

1) Select the option "Output file name as file". >> This auto generates a new column called "File Name" which, can be either just the file name (e.g. 2021Finalreport07)

2) Use the formula tool to extract the relevant part of the file name that indicates the year and concatenate with whatever additional text you need in the new column value.

Note that this will work ONLY IF there are clear pattern in your file names. If there is no pattern in the file name e.g. your file name is "twoThousandN1" it's very challenging for the computer to recognise it as "2001".

Hope this helps.

Dawn.

areeba

Hi @DawnDuong ,

I agree with your second solution,i used the formula tool to extract relevant part. Now i am getting stuck at how to connect or concatenate with the column name not its values.