Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
leobrand
New Contributor II

Inner Join VTable

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.

1 Solution

Accepted Solutions
MVP
MVP

Re: Inner Join VTable

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);

2 Replies
MVP
MVP

Re: Inner Join VTable

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_dimperi
Valued Contributor II

Re: Inner Join VTable

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

Community Browser