Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table 1
ALIBABA
AMAZON
APPLE
BAIDU
DropBox
EBAY
Table 2
ALIBABACOMINC
AMAZONCOMINC
AMAZONCOMINCUS
APPLECANADAINC
APPLEINC
BAIDUUSALLCUS
DropBox
DROPBOXINCWW
EBAY
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
You could use a mapping with mapsubstring() for it.
- Marcus