Qlik Community

Qlik Sense App Development

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

genericdriv
New Contributor II

Joining loaded tables won't work

I am trying to get multiple tables to be associated to each other over the included date.

Therefore I decided to create a relation-table including the load date and the keys of each tuple.

To be able to create this table from previously loaded tables I had to join all the KPI-tables into one big one, from which I could pull the keys with a resident load. Here's where my problem starts:

    [relKPI0]:

   

    load basickpi.Date as Date, *

    resident basickpi;

       

    [relKPI1]:

    left join(relKPI0)

    load aUser.Date as Date, *

    Resident aUser;

    drop table relKPI0;

   

    [relKPI2]:

    left join([relKPI1])

    load dUser.Date as Date, *

    Resident [dUser];

    drop Table [relKPI1];

The execution stops with the error message "Table 'relKPI1' not found: [relKPI2]: left join([relKPI1]) load"

Why doesn't it find the previously created table?