I want to load all sheets from Excel files and store .csv files in a seperate folder.The naming convention should be the First three charactors of the excel file followed by the sheet name.
Say for example, there is a excel file FIN_SCH_Revenue.It contains 10 sheets(tables).
I want to store all the sheets as .csv files with the naming convention like FIN_sheet1.csv..
In QlikView there are few built functions like $filepath,filename use those functions and as you need the first three letters only use LEFT function with a condition like LEFT($filename,3)
In QlikView there are few built functions like $filepath,filename use those functions and as you need the first three letters only use LEFT function with a condition like LEFT($filename,3)
