How to pick partial data match

[SandeepMK]

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

[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

[marcus_sommer]

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

- Marcus