6 Replies Latest reply: Aug 5, 2016 10:12 AM by David Arroyo RSS

    Sense3 - Load 2 excel with the same columns

    David Arroyo

      Good afternoon,

      perhaps it is a simple matter but I'm not finding the solution. I have two Excel files with the same columns. I'm trying to load both files with "concatenate" in order to get one only table with records of both files, but instead I get the two tables separately and a third one with synthetic key that includes all fields.

       

      This is the code:

       

      Dedications:

      LOAD

          "Date"

          "Date / Time"

          Project,

          "Project Category"

          Company,

          Who,

          "Hours"

          minutes,

          "Decimal Hours"

          description,

          "Task List"

          Task,

          "Parent Task"

          "Is Sub-task"

          "Is it Billable?"

          "Invoice Number"

          "Tags"

      FROM [lib: //AttachedFiles/teamwork.xlsx]

      (OOXML, embedded labels, table is Overview);

       

       

      Concatenate (DEDICATIONS)

      LOAD

          "Date"

          "Date / Time"

          Project,

          "Project Category"

          Company,

          Who,

          "Hours"

          minutes,

          "Decimal Hours"

          description,

          "Task List"

          Task,

          "Parent Task"

          "Is Sub-task"

          "Is it Billable?"

          "Invoice Number"

          "Tags"

      FROM [lib: //AttachedFiles/inplants.xlsx]

        (OOXML, embedded labels, table is Inplants);