Table not found

[farolito20]

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]

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]

The first load doesn't have a from 😕

[CELAMBARASAN]

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);