2 Replies Latest reply: Jul 24, 2015 6:22 AM by leila leila RSS

    What difference does the above code with the following code?

      hello dears

      i want Load All Excel File In Folder Dynamically

       

      I wrote as follows no particular problem

      -----------------------------------------------------------------------------------

      Sales :

      LOAD

          FileName() as FileName,RowNo() as RowNumber,

          OrderDate,

          Region,

          Rep,

          Item,

          Units,

          [Unit Cost],

          Total

      FROM

          Sales_*.xls

       

      In this image, that's no problem

      01.png

       

       

       

      But if Wrote

      Only a file called

      What difference does the above code with the following code

       

       

      Load * ,  FileName() as FileName,RowNo() as RowNumber;

      LOAD

          OrderDate,

          Region,

          Rep,

          Item,

          Units,

          [Unit Cost],

          Total

      FROM

          Sales_*.xls

      02.png

      -----------------------------------------------------------------------------------