Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
DeepaTM001
Contributor
Contributor

find out a substring from a string.

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.

 

Labels (1)
4 Replies
martinmichalski
Contributor III
Contributor III

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
Contributor
Contributor
Author

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
Creator II
Creator II


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
Contributor
Contributor
Author

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

Regards!!