Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
I made a mistake, when I grouped by YEAR I had to write LEFT(FileName(), 4) .
Thankyou!!
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.
Hi, Jagan, I've answered that your answer is Helpful. Tks!
Hi,
Is your issue solved? If yes then close this post by clicking Correct answer button to the helpful post.
Regards,
Jagan