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

prayner — Tue, 05 Dec 2023 17:03:24 GMT

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

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

rwunderlich — Tue, 05 Dec 2023 22:14:09 GMT

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

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

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

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