2 Replies Latest reply: Apr 27, 2018 12:47 PM by Eduardo DImperio RSS

    Inner Join VTable

    Leo Brand

      I want to use the sources VTab1 and VTab2 below...

       

      VTab1

      AB
      1aa
      2cc
      3ee

       

      VTab2

      AC
      1xx
      4yy

       

      ..to create VTable below with an inner join...

       

      VTable

      ABC
      1aaxx

       

      Here is my code...

       

      VTab1:

      Inner Join (VTab2)

      LOAD

          A,

          B

      FROM [lib://VTab1.xlsx]

      (ooxml, embedded labels, table is VTab1);

       

      Below is my error message.  I know I need to find a way to Load VTab2 but I am not sure how.

       

      Started loading data

      The following error occurred:

      Table 'VTab2' not found

      The error occurred here:

      VTab1: Inner Join (VTab2) LOAD A, B FROM [lib://VTab1.xlsx] (ooxml, embedded labels, table is VTab1)

      Data has not been loaded. Please correct the error and try loading again.