topic Table not found in QlikView

Table not found

farolito20 — Thu, 03 Jan 2013 20:23:52 GMT

tabla:

load Distinct t_bpid, t_nama,t_seak,t_ccur,ValidFrom,ValidTill,MostRecent,Checksum

from DimCustomers_Day0.qvd (qvd);

Left Join (tabla)

Load

Rowno() as %KeyCustomer

Resident tabla;

STORE tabla into DimCustomers_Day0.qvd (qvd);

DROP Table tabla;

load * from DimCustomers_Day0.qvd (qvd);

help

nagaiank — Thu, 03 Jan 2013 20:28:55 GMT

Try the following:

tabla:

Load

Rowno() as %KeyCustomer;

load Distinct t_bpid, t_nama,t_seak,t_ccur,ValidFrom,ValidTill,MostRecent,Checksum

from DimCustomers_Day0.qvd (qvd);

STORE tabla into DimCustomers_Day0.qvd (qvd);

DROP Table tabla;

load * from DimCustomers_Day0.qvd (qvd);

farolito20 — Thu, 03 Jan 2013 20:34:56 GMT

The first load doesn't have a from 😕

CELAMBARASAN — Thu, 03 Jan 2013 20:47:24 GMT

tabla:

Load

Rowno() as %KeyCustomer;//This is preceding load it loads data from the below load statement

Load Distinct t_bpid, t_nama,t_seak,t_ccur,ValidFrom,ValidTill,MostRecent,Checksum

from DimCustomers_Day0.qvd (qvd);

STORE tabla into DimCustomers_Day0.qvd (qvd);

DROP Table tabla;

load * from DimCustomers_Day0.qvd (qvd);