topic Re: Check for value and get another value from column in QlikView

Check for value and get another value from column

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Check for value and get another value from column

rubenmarin — Sat, 23 Sep 2017 16:41:40 GMT

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

Re: Check for value and get another value from column

Sat, 23 Sep 2017 16:50:36 GMT

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...

Re: Check for value and get another value from column

rubenmarin — Sat, 23 Sep 2017 17:04:12 GMT

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')

Re: Check for value and get another value from column

Sat, 23 Sep 2017 17:43:17 GMT

Thanks Ruben, it works..:)