Resident Load

[#1]

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

[JonnyPoole]

can you share your script ?

[#3]

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;

[JonnyPoole · Accepted solution]

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;

[#5]

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;

[#6]

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?

[#7]

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