Prefix of a file name took as field

[canmarroig]

Hi, i'm loading a certain number of csv files from different dept, referred to budget, and i want to put YEAR in the name of file, in order to extract and use referred amount to analyse different KPIs (ex: YEAR_filename.csv). Every reload i will have to reload different files, 1 for every dept, 1 for every year. Which function in script can help me?

Tks

[javier_florian]

Nop, I have a problem because IT send me different files with no name format, so... I create a temp_sheets to have files names and files sheets... you can load different files with different sheet names

[canmarroig]

I made a mistake, when I grouped by YEAR I had to write  LEFT(FileName(), 4) .

Thankyou!!

[jagan]

Hi,

Please close this discussion by giving Correct and Helpful answers to the posts which helped you.  It helps others to find solution of similar type.

Regards,

Jagan.

[canmarroig]

Hi, Jagan, I've answered that your answer is Helpful. Tks!

[jagan]

Hi,

Is your issue solved?  If yes then close this post by clicking Correct answer button to the helpful post.

Regards,

Jagan