topic Re: Resident Load in QlikView

Resident Load

Fri, 08 Aug 2014 15:14:35 GMT

Resident Load not working on the table loaded using oledb and sql statement. Can any one please help on this issue?

Re: Resident Load

JonnyPoole — Fri, 08 Aug 2014 15:16:02 GMT

can you share your script ?

Re: Resident Load

Fri, 08 Aug 2014 16:01:21 GMT

OLEDB CONNECT TO [Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=C:\Users\sanjay\Desktop\sample\sample.accdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=6;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False];

temp:

SQL SELECT Field1,

ID,

namess,

`rep no s`,

`sample field name`

FROM Table1;

new_table:

load * Resident temp;

drop table temp;

Re: Resident Load

JonnyPoole — Fri, 08 Aug 2014 16:05:40 GMT

Ok so i think its working but because the new resident table has the same fields its autoconcatenating.

Try this

temp:

SQL SELECT Field1, ID, namess, `rep no s`, `sample field name` FROM Table1; new_table:

noconcatenate

NewTemp:

load * Resident temp;

drop table temp;

Re: Resident Load

Fri, 08 Aug 2014 16:30:03 GMT

Just another suggestion. You can do a pre-load like this:

New_Table:

Load *;

SQL SELECT Field1,

ID,

namess,

`rep no s`,

`sample field name`

FROM Table1;

Re: Resident Load

Fri, 08 Aug 2014 16:42:08 GMT

What are you trying to solve? You already loaded the data from SQL SELECT, why another load statement? Are you trying to run QlikView functions on the data that you can't in the SQL SELECT?

Re: Resident Load

Fri, 08 Aug 2014 17:15:26 GMT

yes that's why . Thank you all for your help!