1 Reply Latest reply: Aug 3, 2015 7:37 AM by Marcus Sommer RSS

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

    Marcelo Hernandes

      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!