Load distinct string values from one field to load the same values in a different table.

[prayner]

My aim is to load distinct values in field 'id' (character data type) of table 'plants_table' that match values existing in field 'id' (character data type) of the loaded table 'request_list_table' inside the data load editor.

If I were to do this manually:
SET vRequestIDs = 'id_1', 'id_2'

[plants_table]:
load *

where match(request_id, $(vRequestIDs))

from table

;

However, I haven't successfully created this variable using the field 'request_id'.

My attempts have not produced the right output:

LET vRequestIDs = concat(chr(39)&request_id&chr(39),',');

LET vRequestIDs = peek('request_id',0,'request');

[rwunderlich · Accepted solution]

request_list_table:
LOAD * Inline [
request_id
id_1
id_2
];

[plants table]:
Load *
from ...
where exists(request_id)

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com