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