Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
luckyland
Contributor
Contributor

How to load from another table

Dears

i have 2 qvds (score & base) (or 2 txts)

table1_score:

Load NAME,

       SCORE

From score.qvd ;

table2_base:

Load NAME,

        GENDER

From base.qvd

where GENDER='M' ;

can i select table1 just GENDER='M' ?

From score.qvd WHERE NAME IN(SELECT......??)

2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

You could use exists() to filter your data, maybe in this way:

table2_base:

Load NAME, GENDER

From base.qvd where GENDER='M';

table1_score:

Load NAME, SCORE

From score.qvd where exists(NAME);

Another possibility would be to create a mapping table from the table, like:

table2_base:

mapping Load NAME, GENDER

From base.qvd;

table1_score:

Load NAME, SCORE

From score.qvd where applymap('table2_base', NAME, '#NV') = 'M';

- Marcus

shiveshsingh
Master
Master

hi

You can use applymap function

table2_base:

MAPPING Load NAME, GENDER

From base.qvd;

table1_score:

Load *, applymap('table2_base', NAME, 'NA') AS X

From score.qvd where X = 'M';