Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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.
Try
Load * resident Location_Coordinates;
Regards,
Kaushik Solanki
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
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.