topic Re: Refer a Column from other Column in QlikView

Refer a Column from other Column

yashcena — Mon, 08 Oct 2018 09:07:25 GMT

Hi,

I have Resource_Name, ResourceID and ManagerID in my data model

How do I fetch the ManagerName from this data? I'm still learning qlikview script syntaxes and any help would be appreciated.

Thanks,

YASH

Re: Refer a Column from other Column

niclaz79 — Mon, 08 Oct 2018 09:18:35 GMT

Hi,

From you file I can see that you don't have Manager Name. However if you have a file that has the Manager Name you can load that file to another table together with Manager ID and the tables will link automatically (they always do when two columns have the same name in two separate tables).

Re: Refer a Column from other Column

yashcena — Mon, 08 Oct 2018 09:24:39 GMT

I dont have ManagerName stored anywhere separately. I need to make use of this data only to fetch the Manager Name. Can Inner Join be used? I'm not sure how to write it up.

Re: Refer a Column from other Column

rajivmeher — Mon, 08 Oct 2018 09:41:45 GMT

Hi Yash

I guess you want to get the manager name from resource name based on ManagerId and ResourceID match (correct me if I am wrong).

In that case you can load all resources data into a mapping table and applymap based on ManagerID column to get the required data.

Please see the attached QVD for example. Please note that I haven't reloaded the model because I didnt had the EXCEL file. You can reload it on you side and see if it works.

Regards

Rajiv.

Re: Refer a Column from other Column

PrashantSangle — Mon, 08 Oct 2018 09:54:17 GMT

use self join concept over here. You have to join same table to the existing table only while joining you have to rename resource_id field as manager_id

try below logic

Load Resource_id,

Resource_name,

Manager_id

From tableName;

Left Join

Load Resource_id as Manager_id,

Resource_name as Manager_name

From tableName;

Regards,