Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
SandeepMK
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
Josh_Berg_Support

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.
marcus_sommer
MVP & Luminary
MVP & Luminary

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

- Marcus