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
Solved! Go to Solution.
Hi @atcodedog05
Please find updated wokflow and expected output attached.
Note : Column Year must be updated as per the Filename
Regards
Areeba
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.
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
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
Happy to help : ) @areeba
Cheers and have a nice day!