Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Table Not Found when using left join

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

1 Reply
MVP
MVP

Re: Table Not Found when using left join

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...

Community Browser