Discussion board where members can get started with Qlik Sense.
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:
LIB CONNECT TO [DATABASE_SERVER];
SQL SELECT "name" as sitename,
Load * from Location_Coordinates;
I get the following error:
The following error occurred:
Go to Solution.
You need to use Resident Load instead of From, check below script
Load * RESIDENT Location_Coordinates;
Hopt this helps you.
Load * resident Location_Coordinates;
to load data from a previously loaded table you need a resident load