Populate temp table from a table that was just loaded.

[#1]

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.

[kaushiknsolanki]

Try

Load  * resident Location_Coordinates;

Regards,

Kaushik Solanki

[maxgro]

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 · Accepted solution]

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.