Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I was able to accomplish this using the load script in the attached QVW.
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
I was able to accomplish this using the load script in the attached QVW.
Hi Marcus thanx a lot for your suggestion. It works fine
Thanx Ken.