Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
proctors
Contributor

Table Not Found Resident Load

 

I'm running a script like the following, but getting an error that my last table Group_Data_Amb cannot find the Resident table. In other forums people suggested NoConcatenate, however even though both of the DCAPBS tables load, the third fails to load. What am I missing? (And yes, I have a very specific reason for loading a duplicate table, which will be dropped once the error goes away).

 

Table not found error
Table 'DCAPBS_DUPE' not found
Group_Data_Amb:
NoConcatenate
LOAD
"Provider Name"
Resident
DCAPBS_DUPE

DCAPBS:
NoConcatenate LOAD distinct *
;
SQL
Select Distinct
ACCESS,
"Provider Name",
"Billing Provider"
From TABLE A;

DCABPS_DUPE:
NoConcatenate LOAD distinct *
;

SQL
Select Distinct
ACCESS,
"Provider Name",
"Billing Provider"
From TABLE A;

Group_Data_Amb:
NoConcatenate LOAD
"Provider Name"
Resident
DCAPBS_DUPE;




 

Labels (1)
1 Solution

Accepted Solutions

Re: Table Not Found Resident Load

Hi, one is DCABPS_DUPE, the other DCAPBS_DUPE

1 Reply

Re: Table Not Found Resident Load

Hi, one is DCABPS_DUPE, the other DCAPBS_DUPE