Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to pick partial data match

How to fetch data from Table 2 if there is a keyword/partial match in comparison with Table 1 ? 
 

Table 1

ALIBABA

AMAZON

APPLE

BAIDU

DropBox

EBAY

 

Table 2

ALIBABACOMINC

AMAZONCOMINC

AMAZONCOMINCUS

APPLECANADAINC

APPLEINC

BAIDUUSALLCUS

DropBox 

DROPBOXINCWW

EBAY

Labels (1)
2 Replies
Highlighted

Re: How to pick partial data match

Can you please elaborate on what your goal is?  I understand you're looking for a way for Qlikview to identify a partial match in Table 1 and look for it in Table 2, but then what would you like to happen?

Thanks,
Josh

Qlik Support

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Highlighted
MVP & Luminary
MVP & Luminary

Re: How to pick partial data match

You could use a mapping with mapsubstring() for it.

- Marcus