Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Populate temp table from a table that was just loaded.

I'm trying to load a temp table with data from another table, via the Data Load Editor, but I'm getting an error.

Here is my code:

[Location_Coordinates]:

LIB CONNECT TO [DATABASE_SERVER];

LOAD [sitename],

  [latitude],

  [longitude];

SQL SELECT  "name" as sitename,

  "latitude",

  "longitude"

FROM "DATABASE_SERVER"."dbo"."locations";

[VTable]:

Load * from Location_Coordinates;

I get the following error:

The following error occurred:

Invalid Path

---

The error occurred here:

[VTable]:

Load * from Location_Coordinates
I also tried populating the temp table in another script, but that didn't help.
I can see that Location_Coordinates is populated correctly via the data manager.  So I'm not sure what the issue is.

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

HI,

You need to use Resident Load instead of From, check below script

[Location_Coordinates]:

LIB CONNECT TO [DATABASE_SERVER];

LOAD [sitename],

  [latitude],

  [longitude];

SQL SELECT  "name" as sitename,

  "latitude",

  "longitude"

FROM "DATABASE_SERVER"."dbo"."locations";

[VTable]:

Load * RESIDENT Location_Coordinates;


Hopt this helps you.


Regards,

jagan.

View solution in original post

3 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Try

Load  * resident Location_Coordinates;

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
maxgro
MVP
MVP

to load data from a previously loaded table you need a resident load

https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/LoadingResidentTables.htm

jagan
Luminary Alumni
Luminary Alumni

HI,

You need to use Resident Load instead of From, check below script

[Location_Coordinates]:

LIB CONNECT TO [DATABASE_SERVER];

LOAD [sitename],

  [latitude],

  [longitude];

SQL SELECT  "name" as sitename,

  "latitude",

  "longitude"

FROM "DATABASE_SERVER"."dbo"."locations";

[VTable]:

Load * RESIDENT Location_Coordinates;


Hopt this helps you.


Regards,

jagan.