Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
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.