Is there a vlookup function in QV

[n1ef5ng1]

Hi all, I have two tables namely :Connectivity and Vessel_Details

In the Vessel Details , I have the following fields : Vessel_Name, Voyage_No and Vessel_Direction. This contains a list of ALL vessels

For the Connectivity I have, Load_Vessel_Name ,Load Voyage_No, Disc_Vessel_Name, Disc_Voy. This shows the connection between vessels that discharge and vessels that load

Note that the Load_Vessel_Name and Load_Voyage are connected to Vessel Details Vessel_Name and Voyage_No. Hence I am able to get the Load_Vessel_Direction by using Vessel Direction.This is done through connectivity_Key

However, I am stuck as I would need to create Disc_Direction by using 'mapping' on the Vessel_Name and Voyage_No. Is there anywhere i can do this in script level

I have attached the file. I need a new field call Disc_Direction

[john9inno]

HI

it looks like you are from excel background to QV.

very much like myself.

Applymap works similar to V-lookup however, you can't select comumn numbers.

you load mapping table that only contains key value and lookup value.

applymap('Talbe name',keyvalue)

Tanks.

[vikasmahajan]

Lookup and Apply map  two commands are there in Qlikview search for that.

Vikas

[Colin-Albert]

Applymap is the equivalent of Vlookup.

There is an explanation of how this one use mapping tables and applymap hereDon't join - use Applymap instead

[Anonymous]

Hi Benn,

Check out this link http://www.analyticsvidhya.com/blog/2014/07/vlookup-functionality-qlikview/

Hope this will help you

[jagan]

Hi,

Check this thread for Lookup example

Lookup function

Regards,

Jagan.