topic Re: How to load from another table in QlikView

How to load from another table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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......??)

marcus_sommer — Fri, 28 Apr 2017 15:38:23 GMT

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 — Sun, 30 Apr 2017 11:49:45 GMT

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';