Can't find table

pauldamen — Tue, 08 May 2018 07:46:59 GMT

Dear all,

I have the below load script. When using this script it generates the error; Can't find Lead Table. But I don't understand why, I just generate it and try to concatenate something to it. Any thoughts?

Regards, Paul

NewLead:

Load

URL as CRM_URL,

Leadscore,

FirstName as Voornaam,

FullName as VolledigeNaam,

LastName as Achternaam,

SaveDate as Datum

Resident DimContact;

Store NewLead into (qvd);

Lead:

Load

CRM_URL,

Leadscore,

Voornaam,

VolledigeNaam,

Achternaam,

Datum

FROM [lib://XXXXX.qvd](qvd);

Concatenate(Lead)

Load

CRM_URL,

Leadscore,

Voornaam,

VolledigeNaam,

Achternaam,

Datum

Resident NewLead;

Store NewLead into (qvd);

Drop Table NewLead;

Re: Can't find table

Lisa_P — Tue, 08 May 2018 07:51:29 GMT

Lead table is not created as the load will be auto concatenated to NewLead. If you want to keep the first two tables separate you will need to use the NOCONCATENATE before the load statement for the Lead table.

topic Can't find table in App Development

Can't find table

Re: Can't find table