find out a substring from a string.

[DeepaTM001]

Hi All,

Could you please help us with the below mentioned Qlik Issue, Would be a great help.

Problem:

I have to find out a substring from a string.

Table 1

Derived EunameKeywords ALIBABA

BAIDU

AMAZON

APPLE

BAIDU

DropBox

EBAY

GSICommerce

Qihoo

RACKSPACE

TENCENTAMERICA

USALIBABA

YAHOO

TABLE 2

Derived EU Name

RACKSPACE HOSTING INC - US

AMAZONCOM INC - US

APPLE INC - US

MICROSOFT CORPORATION - US

MOTOROLA SOLUTIONS INC - US

FACEBOOK INC - US

APPLE FEDERAL CREDIT UNION -

APPLE, INC

Here I have to pick DerivedEUname from Table 2 based on the keyword provided in Table 1.

Imagine that Table 1 contains AMAZON so I have to get AMAZONCOM INC - US details from Table 2.

(If  the keywords from Table 1 is contained in the values in Table 2 then have to select the fields from Table 2)

Could anyone please try this. Thanks.

[martinmichalski]

Are working on frontend or script?

If its the script, you could use MapSubstring:

 https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/MappingFunctio...

[DeepaTM001]

Hi Martin,

Thank you so much.

I am trying the code in frontend. I tried the below code but unluckily it didn't work.

would you help me to fix this.

[Marcos_rv]

you should use a lookup table and make the tables talk about the same, I recommend you use an excel, since you don't have a field that contains a string and you can do a split to get the value that matches the value of the other table.

Regards!!!

[DeepaTM001]

sorry, but I have millions of data in Table 2 and it is taking additional time in Excel. 

Regards!!