Combine tables with wildcard Join

schmidtj — Sat, 16 Nov 2024 18:44:15 GMT

Hi,

i would like to achieve the following and dont really know how - here is an example:

I have table A with one column 'text'. The data in that column is unstuctured text (1 to max. 50 words per row).
I have another table B with one columns 'tags', including search words (single word per row).

In my app i would like to display both tables.
When the user filters however a word from table B, all rows from table A should be filtered where the word from B
is among the unstructured text of each rom from A. So basically a full wildcard search per row in A.

I guess thats quite easy in Qlik to do but i just cant get the data load for that done.

Can somebody help me with that?

Re: Combine tables with wildcard Join

Oliver_F — Mon, 27 Apr 2020 10:30:20 GMT

Hi,

if your data set is not too big, you can use subfield to avhieve what you are looking for:

===========

Input:
load * inline [
Text
This is a long text.
This is a Qlik Sense Scripting Example.
];

Tags:
load * inline [
Word, Tag
This, T-Word
is, i-Word
is, 2-Letter-Word
a, 1-Letter-Word
];

Data:
load
Text,
SubField(Text,' ') as Word
Resident Input;

drop table Input;

=============

If your data set is too big for this solution, I would give each sentence an ID and build a Bridge table using the subfield method from above.

All the best

Oliver

topic Re: Combine tables with wildcard Join in App Development

Combine tables with wildcard Join

Re: Combine tables with wildcard Join