Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Drop Table NewLead;
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.