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

[#1]

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!

[sinanozdemir]

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.