8 Replies Latest reply: Oct 19, 2015 1:45 PM by Joanne Mammarelli RSS

    joining to an already created table

      Hi - rookie user here ...

       

      I have spreadsheets that are all tied together with a hostname.

       

       

      LOAD hostname,
      group
      ,'1'
      FROM
      [C:\Users\v374914\Documents\MyDocs\UD10Sept27\Sept2015-CA441101-CMIST2469710-UD10-VZSolaris.xlsx]
      (
      ooxml, embedded labels, table is VZSolaris);

      noconcatenate
      LOAD hostname,
      group
      ,'2'
      FROM
      [C:\Users\v374914\Documents\MyDocs\UD10Sept27\Sept2015-CA441101-IPM6535899-UD10-fNTEC-Linux.xlsx]
      (
      ooxml, embedded labels, table is fNTECLinux);

       

      etc ...

       

       

      After I "tie" all of the sheets together, I created a 'table box' which gives me a nice start for what I'm looking for.

       

      Ideally, is there a way I could tie all of those spreadsheets together into the form of a table (basically create the table box as a data table), THEN, add some more logic to left join the newly created table against another table.

       

      Thanks.

       

      Joanne