Count if one field contains text from other field

[Anonymous]

Hi all,

I need you help please with Qlik Sense.

I have two tables:

1. [Table1]:
   
2. [Table2]:
   

*note: REASON_CODE_SLOV could be a sentence and not just a one word.

I would like to create a pivot table that count if REASON_CODE_SLOV (from Table2) is in REASON_CODE_MLOV (from Table1).

For example:

What will be the function I should use to count the words/text from Table2 if Table1 contains them?

[Anonymous · Accepted solution]

Sum(If(WildMatch(Reason_Code_Mlov, '*'&Reason_Code_Slov&'*'), 1, 0))