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.
