Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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......??)
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
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';