topic Re: Nested Loop in Connectivity & Data Prep

Nested Loop

ABC_123 — Wed, 14 Sep 2022 20:28:04 GMT

I would like to create a LOAD statement that basically performs a nested loop.

For the first ID in the Sentence table, scan the OLD_TEXT field to look for the first item in the REMOVE_TEXT field of the WordsToRemove table. If that words/phrase is found, REPLACE it with blanks (''). Repeat for each item in the WordsToRemove table until ID (A) is has removed all relevant words. Then, repeat that process for every item in the ID field.

Is this possible?

Sentence

ID	OLD_TEXT
A	The car was brown.
B	The car was green.
C	The car was blue.
D	The car was orange.
E	The car was blue green.
F	The car was yellow.

WordsToRemove

ID2	REMOVE_TEXT
1	blue green
2	brown
3	blue
4	car

Re: Nested Loop

marcus_sommer — Thu, 15 Sep 2022 10:20:06 GMT

It might be done with mapsubstring() - see: Mapping with conditions - Qlik Community - 1981209 and just add '' as return and skip the textbetween().

- Marcus

Re: Nested Loop

Ruhulessin — Thu, 15 Sep 2022 10:41:16 GMT

Hi @ABC_123 ,

Like @marcus_sommer says, you can use MapSubString to map '' to the words that it can find in the mapping table.
PFA an example.

-Ruben