Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
pauldamen
Partner
Partner

Can't find table

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;

1 Reply
Lisa_P
Employee
Employee

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.