Automate Column name with File name

[areeba]

Hi @atcodedog05 

I have a requirement where my column name has to be update with file name .

for example :

I have 2 files with the name:

1) 2021Finalreport07

2)Monthly 12-2020

From each file I need to create a column , where column name picks up the year from the file name.

column name should be like of file1: Budget Year 2021

column name should be like of file2: Budget Year 2020

Idea is to automate the column names every year as per the filename year.

Can you give suggestions?

Regards

Areeba

[areeba]

Hi @atcodedog05 

Please find updated wokflow and expected output attached.

Note : Column Year must be updated as per the Filename

Regards

Areeba

[atcodedog05]

Hi @areeba 

In the expected output provided by you, it has only 2022 year. In the workflow we have both 2022 and 2021. Can you confirm will there be a single year if not can you please provide the exact output expected from the workflow.

[areeba]

Hi @atcodedog05 

I am sorry for inconvenience (thoda twist hai) .

I have 2 excel files

File1: 2022FinalReport07

File2: 2021YearlyReport07

Here File1 has 2 columns : Budget Year and Forecast Year

File2 has 2 columns: Budget YTD and Forecast  YTD

i have to do totals, sub total and Grand totals

only thing is column names should be updated as per the Filename year. right now its 2022 and 2021 next time it will be 2023 and 2022. columns names should be updated dynamically.

in this example i gave you two columns but in real workflow i have 10 columns each.

Please find attached Expected output

Regards

Areeba

[areeba]

Hi @atcodedog05 

I am explain it from beginning. I have 2 excel files(attached).

File1: 2022FinalReport07

File2: 2021YearlyReport07

Here File1 has 2 columns : Budget Year and Forecast Year

File2 has 2 columns: Budget YTD and Forecast YTD

I have to do totals, sub total and Grand totals (Grouping A,B,C(total) and Grouping D,F,G(sub_total)  and then final Grand total (total + Sub_total) see expected output)

The column names should be updated as per the Filename year

File1 Columnn Should be Budget Year 2022 Forecast Year 2022

File 2 Column should be Budget YTD 2021 Forecast YTD 2021

next time file names will be change to different year , so the main idea is to dynamically update column names as per file name year of it.

Please find attached input files and expected output file.

Please let me know if anything is not clear.

Regards

Areeba

[atcodedog05 · Accepted solution]

Hi @areeba 

Here is how you can do it.

Workflow:

Hope this helps : )

[areeba]

Hi @atcodedog05 

Thanks for the Help 🙂

[atcodedog05]

Happy to help : ) @areeba 

Cheers and have a nice day!