topic lookup a string in QlikView

lookup a string

omerbamba — Sun, 24 Sep 2017 11:51:23 GMT

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

sunny_talwar — Mon, 25 Sep 2017 12:01:53 GMT

May be use Mapping Load with ApplyMap

mdmukramali — Mon, 25 Sep 2017 12:05:17 GMT

Dear Omer,

can you attached sample data file.

Thanks,

Mukram

MarcoWedel — Tue, 26 Sep 2017 20:23:59 GMT

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 — Tue, 26 Sep 2017 20:30:53 GMT

Best solution is to use

MAPSUBSTRING function. IT IS A SISTER FUNCTION TO APPLYMAP

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