10 Replies Latest reply: Jul 9, 2015 7:26 AM by Stefan Wühl RSS

    Multiple file load wither inner join

      Hello,

       

      I have tried to load from multiple files 3 tables, which I wanted to concatenate. So I've used the Load From [Path\*.xlsx] (all my files ae xlsx and in the same folder).

      Rapport1:

      LOAD *

      FROM [pahtfield*.xlsx](ooxml, embedded labels, table is [Rapport 1]);

       

      inner join (Rapport1)   

      LOAD *

      FROM

      [pathfield\*.xlsx]

      (ooxml, embedded labels, table is [Rapport 2]);

       

      But I had no data loaded

       

      Any one can help my with this?

       

      Thank you