Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be use Mapping Load with ApplyMap
Dear Omer,
can you attached sample data file.
Thanks,
Mukram
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
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.