Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to select data from created data model in qlik sense.

I created a different model for but same table. Example I load some data from my table property and I name it Property. I load some data again from my table property with specific selected data and named it Property 2.

Property

data1

data2

Property2

data1

data2

I load data in property using this SQL QUery;

[Property]:

Load data1,

data2;

SQL SELECT data1,

data2

FROM PROP.PUB.Property;

I load data in property2 using different SQL query;

[Property2]:

Load data1,

data2;

SQL SELECT data1,

data2

FROM PROP.PUB.Property

WHERE data2 <=2015;



Is it possible to select or load data from property2? For example

[Property3]:

Load data1,

data2;

SQL SELECT data1,

data2

FROM Property2;



Property2 is only created in qlik sense not literally table in my database. Any solution? Thanks for help!


1 Reply
sinanozdemir
Specialist III
Specialist III

Yes, you can use Resident in your load script:

[Property3]:

LOAD

         data1,

         data2

Resident [Property2];

Just be aware of the natural concatenation when the field names are the same.

Hope this helps.