join, mapping or is there a better way to reduce data load in qliksense

[happyfeet11]

Dear All,

 I am trying to understand the following and would urgently need your help:

I have a query with data extracted from two table with where conditions which i have generated in SQL and now need to adapt to Qliksense script. it generated about 500 datapoints.

how can i extract the same  filtered data from  the two tables   which has a primary key common to both tables and avoid  loading all the data?

i have tried resident ::: didnt work ? dont know what i was doing wrong?

i have tried mapping : again dont know what was wrong.

most imporatnt thing is i am new to qliksense 🙂

I look forward to your help.

thanking you

Regards

Indrani

[y_grynechko]

Good Morning, 

mapping load is a good approach here.

Before you load the tables create mapping like this:

NameOfMapping:
Mapping Load
ID,
FieldYouWantToMapToID
FROM [lib://TableYouWantToSourceMappingFrom](qvd);

After that when you load the table you want to filter by mapping use something like this:

TableName:

LOAD
ID,

SomeField,

SomeField2
FROM [lib://OtherTableWithSameIDAsMapping](qvd)
where
ApplyMap('NameOfMapping', ID, null()) = 'SomeFilterValue';