topic Re: Inner Join VTable in App Development

Inner Join VTable

leobrand — Fri, 27 Apr 2018 03:53:07 GMT

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

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.

Re: Inner Join VTable

petter — Fri, 27 Apr 2018 04:13:24 GMT

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

VTab2:

LOAD

FROM [lib://VTab2.xlsx]

(ooxml, embedded labels, table is VTab2);

Inner Join (VTab2)

LOAD

FROM [lib://VTab1.xlsx]

(ooxml, embedded labels, table is VTab1);

Re: Inner Join VTable

eduardo_dimperio — Fri, 27 Apr 2018 16:47:21 GMT

Two ways same result:

VTable:

LOAD

FROM Table1

inner join (VTable)

Load

FROM Table2

VTable:

LOAD

FROM Table2

inner join (VTable)

Load

FROM Table1