lookup

[Anonymous]

Hi Guys,

I have two column A  and B

A    B  C

1    a   N/A
2    1    1

3    c    N/A

4    2    2

5    d     N/A

Now i need to calculate a field C where it will check row wise like B column first row value is a, it will search a  in full A column and if it finds the same value it should return a or else n/a.

PLEASE HELP ME ON THIS

[marcus_malinow]

Hi Rajashmita,

this sounds like the sort of issue that ApplyMap could resolve.

To build your mapping table

MappingTable:

MAPPING LOAD

     A, A

FROM .....

Then user it like this

ApplyMap('MappingTable', B, 'N/A')

Steve Dark did a great blog post on ApplyMap - http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Marcus

[#3 · Accepted solution]

I was able to accomplish this using the load script in the attached QVW.

[Anonymous]

Hi Marcus thanx a lot for your suggestion. It works fine

[Anonymous]

Thanx Ken.