Inner Join VTable

[leobrand]

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

VTab1

A	B
1	aa
2	cc
3	ee

VTab2

A	C
1	xx
4	yy

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

VTable

A	B	C
1	aa	xx

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.

[petter · Accepted solution]

You will have to load the VTab2 before you try to join it to anything else.....

VTab2:

LOAD

    A,

    C

FROM [lib://VTab2.xlsx]

(ooxml, embedded labels, table is VTab2);

Inner Join (VTab2)

LOAD

    A,

    B

FROM [lib://VTab1.xlsx]

(ooxml, embedded labels, table is VTab1);

[eduardo_dimperio]

Two ways same result:

VTable:

LOAD

*

FROM Table1

inner join (VTable)

Load

*

FROM Table2

OR

VTable:

LOAD

*

FROM Table2

inner join (VTable)

Load

*

FROM Table1