Qlik View Table Not Found Resident Load

[ganeshgca]

I am getting the below error

Table not found error

Table 'PS1_NAST_ZBI0' not found

RIGHT JOIN(PS1_NAST_ZBI0)

NoConcatenate
LOAD
MAX(ZBI0_Created_On) as ZBI0_Created_On,
MAX(ZBI0_Created_At) as ZBI0_Created_At,
ZBI0_Type,
Billing_doc
RESIDENT PS1_NAST_ZBI0
GROUP BY ZBI0_Type, Billing_doc

Below is my script

in Tab1

details of PS1_VBRK table load is perfectly fine

in Tab5 - 

//ZBI0 - NAST

Left Join(PS1_VBRK)

PS1_NAST_ZBI0:
LOAD
ERDAT as ZBI0_Created_On,
ERUHR as ZBI0_Created_At,
KSCHL as ZBI0_Type,
OBJKY as Billing_doc,
VSTAT as ZBI0_Status
FROM
$(SAPPath_New)$(SAPPrefix_New)NAST.qvd
(qvd)
WHERE KSCHL = 'ZBI0';

RIGHT JOIN(PS1_NAST_ZBI0)

NoConcatenate
LOAD
MAX(ZBI0_Created_On) as ZBI0_Created_On,
MAX(ZBI0_Created_At) as ZBI0_Created_At,
ZBI0_Type,
Billing_doc
RESIDENT PS1_NAST_ZBI0
GROUP BY ZBI0_Type, Billing_doc;

Data in PS1_NAST is as below

OBJKY (Billing_doc)	KSCHL (ZBI0_Type)	ERDAT (ZBI0_Created _On)	ERUHR (ZBI0_Created_At)	VSTAT (ZBI0_Status)
0090324700	ZBI0	10/10/2020	1:55:31 AM	1
0090324700	ZBI0	3/11/2021	10:15:26 PM	0

[MarcoWedel]

do you expect 

Left Join(PS1_VBRK)

PS1_NAST_ZBI0:

to join to PS1_VBRK and at the same time to create a new table PS1_NAST_ZBI0 ?

It will instead just join to PS1_VBRK but it won't create PS1_NAST_ZBI0.

You could try loading PS1_NAST_ZBI0 at first and subsequently join a resident load from PS1_NAST_ZBI0.

[Kamryn]

Add NoConcatenate after the table name

GarageBand App