Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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.

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Populate temp table from a table that was just loaded.

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.

3 Replies

Re: Populate temp table from a table that was just loaded.

Try

Load  * resident Location_Coordinates;

Regards,

Kaushik Solanki

MVP
MVP

Re: Populate temp table from a table that was just loaded.

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

MVP
MVP

Re: Populate temp table from a table that was just loaded.

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.

Community Browser