Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
omerbamba
Contributor
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

4 Replies
sunny_talwar

May be use Mapping Load with ApplyMap

What is a Mapping Load in Qlikview

mdmukramali
Specialist III
Specialist III

Dear Omer,

can you attached sample data file.

Thanks,

Mukram

MarcoWedel

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
Creator III
Creator III

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.