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

Sun, 02 Aug 2015 23:15:39 GMT

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!

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

marcus_sommer — Mon, 03 Aug 2015 11:37:21 GMT

- Marcus