Check for value and get another value from column

[#1]

Hi,

I am new to qlikview and trying to identify the best way to find a value from 2nd table based on the value from 1st table and retrieve another value from 2nd table.

Let me take an example:

Employee:

EmployeeID    ,     EmployeeName     ,     DeptID

Dept:

DeptID     ,     DeptName

Here goes my question:

How can i retrieve:

EmployeeDetails:

EmployeeID     ,     EmployeeName     ,     DeptID     ,     DeptName

Could you please help further on this?

[rubenmarin]

Hi Kamuru, having that tables the data is linked by DepID. I you want the data in a single table you can try with:

EmployeeDetails:

LOAD EmployeeID    ,     EmployeeName     ,     DeptID

FROM/Resident ... //employee data

Left Join (EmployeeDetails)

LOAD DeptID     ,     DeptName

FROM/Resident ... // Dept data

[#3]

Thanks Ruben,

but here's the probelm, few of the employees are not having any Dept.

In this case, could you please help on how to proceed further.

I have trying to use applymap but not able to...

[rubenmarin]

If there is no Dept for employees, Wich Dept or value for Dept has to be assigned?

Applymap has a 3rd parameter to assign not found values:

Applymap(mapDept, DepID, 'No Dept Assigned')

[#5]

Thanks Ruben, it works..:)