Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

omerbamba
New Contributor

lookup a string

Hi QV community

My question is simple, hope you can help.

I loaded 2 tables - the first one contain a list of "Teams Name".

In the second table I loaded another table that one column is containing some of the names of the "Teams Name" and some other names.

Now, I want to find the Match name and put them in a new Column, lets say "Teams Name Match".

I tried with lookup func. but without success.

Thx

Omer

Tags (2)
4 Replies

Re: lookup a string

May be use Mapping Load with ApplyMap

What is a Mapping Load in Qlikview

mdmukramali
Valued Contributor III

Re: lookup a string

Dear Omer,

can you attached sample data file.

Thanks,

Mukram

Re: lookup a string

Hi,

maybe you can use the Exists() function in your table2 load statement, e.g. like this:

If(Exists(TeamsName, TeamsNameTable2), TeamsNameTable2) as TeamsNameMatch

hope this helps

regards

Marco

vkish16161
Contributor III

Re: lookup a string

Best solution is to use

MAPSUBSTRING function.   IT IS A SISTER FUNCTION TO  APPLYMAP


MapSubstring ‒ QlikView


It works on parts of string, unlike ApplyMap that works on the whole value in Field.