Table Not Found when using left join

Sun, 10 Aug 2014 04:24:45 GMT

Tab1

$(qvd_name)

: Load

[ID Number] ,
[Department Name]

from

QVD\Layer 2\T_Department.qvd](

qvd)

Tab 2

left join

NoConcatenate
[table 2]

LOAD
[ID Number] ,
[Hiire Date]
FROM
(qvd)

Where [Hire Date] >0;

[Employee Rec]

Load

[ID Number],

max(Hire Date]) as [Date Hire]

Resident

[table 3]:]:
load
[ID Number] ,
max(s483_Dt) as [483 Dt],
max(s324_Dt) as [324 Dt],
max(s367_Dt) as [367 Dt]
Resident [tabe 2]
Group by [ID Number];

drop Table [table 2];

STORE

$(qvd_name) into $(qvd_layer_3_path) $(qvd_name).qvd (qvd);

In this example table 1 is the source table. Table 2 has a common field called ID

Re: Table Not Found when using left join

MK_QSL — Sun, 10 Aug 2014 06:05:08 GMT

Left Join and NoConcatenate ?

Remove NoConcatenate !!

Also,when you are using Max([Hire Date]), you need to group by ID Number....

Provide your exact error...

topic Re: Table Not Found when using left join in QlikView

Table Not Found when using left join

Re: Table Not Found when using left join