Qlik Community

Qlik Sense App Development

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

Highlighted
acbishop2
Contributor

"Table not found" (Resident [GenericTable])

Hello all,

I've hit an unexpected error. Here's the simplified version:

I need to join some tables together. One table contains application details. The other contains application statuses.

AppDetails:

AppIdAppNameAppDetail1AppDetail2
12345John Doe1Blue
12346Jane Doe0Yellow
12347Mickey Mouse1Blue

AppStatuses:

AppIdStatusStartDate
12345ApplicationStarted9/9/2018
12345ApplicationCompleted9/10/2018
12346ApplicationStarted9/9/2018
12346ApplicationAbandoned9/11/2018

I needed to measure time between statuses, so I used the generic load to make AppStatuses more workable:

AppIdApplicationStartedApplicationCompletedApplicationAbandoned
123459/9/20189/10/2018
123469/9/20189/11/2018

I am now trying to join the two together, but I'm getting an error that the table is not found. Here's what my simplified script would look like:

[AppStatuses]:

Generic Load

     AppId,

     Status,

     StartDate

From ...[Source];

[Table Join]:

Load

     AppId,

     AppName,

     AppDetail1,

     AppDetail2

From ...[Source];

Join

Load

     AppId,

     ApplicationStarted,

     ApplicationCompleted,

     ApplicationAbandoned

Resident [AppStatuses];

Drop Table [AppStatuses];

The error I get while loading the script is "Table 'AppStatuses' not found." I searched the error and found suggestions that I should use the NOCONCATENATE prefix on the first table, but that gives me an "Illegal Prefix Combination" error. Someone might suggest not using JOIN at all, but in this case I need to because later in the script, I am creating calculated fields based off of fields in both tables.

Any ideas? All help is greatly appreciated.

1 Reply
vamsee
Valued Contributor

Re: "Table not found" (Resident [GenericTable])

The reason for table not found is because Generic Load creates Multiple tables.

The Generic Load

You might have to do multiple joins post the generic load statement to merge them back into single table.

If you want to get the time between statuses try Age()

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFun...