4 Replies Latest reply: Jul 15, 2010 10:20 AM by sundarav RSS

    Concatenating loads from Excel files

    sundarav

       

      All,

      Maybe this might have been asked/answered before, but here's the issue I'm having :

      Table:

      LOAD

      .

      .

      FROM Folder\Name-*.xls

      does not seem to concatenate the excel files while I have seen similar code work in concatenating *.qvd files. With the above code, the data goes into a new table for each file.

      Any ideas on what/how I could change the code for concatenation? Thanks.

      -Sandy.