Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Loading the same files with different table's names - XLSX Files

I have to load a lot of tables from excel (xlxs) files (File_1, File_2 etc).

Each month there's a new file. In order to load all files at once, I use the character "*" before the file name's end.  Something like this:

FROM

[File*.xlsx]

But recently, the table's name has changed sometimes. 'Table_No' instead of 'Table_Yes', for example.

Today, the only way to correct this here is renaming the tables in the files source.

But it takes a lot of time, considering that we have dozens of files monthly.

How can I do this through load script, considering that I use the character "*" before the file name's end in the script?

Thanks!

Tags (4)
1 Reply
marcus_sommer
Not applicable

Re: Loading the same files with different table's names - XLSX Files