How to load from another table

[Anonymous]

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]

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]

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