Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Join 2 resident tables

Hi,

I get the following error when I try to exccute this script

CT4:

LOAD * Resident

[CT];

left Join (CT4)

LOAD * Resident

CT2;

Table not found

left Join (CT4)

LOAD * Resident

CT2

Both CT and CT2 carry an ID field

1 Solution

Accepted Solutions
Highlighted

Re: Join 2 resident tables

Try with

CT4:

NOCONCATENATE

LOAD * Resident

[CT];

left Join (CT4)

LOAD * Resident

CT2;

Because The table CT4 is automatically concatenated to CT

View solution in original post

1 Reply
Highlighted

Re: Join 2 resident tables

Try with

CT4:

NOCONCATENATE

LOAD * Resident

[CT];

left Join (CT4)

LOAD * Resident

CT2;

Because The table CT4 is automatically concatenated to CT

View solution in original post