topic Re: How Can I link 2 Columns in a Same Table in QlikView

How Can I link 2 Columns in a Same Table

Naman_Vyas — Sun, 25 Jul 2021 06:51:19 GMT

For Example I have a table lets say Data

In Data table we have 5 fields Lets say

A, B , C , D , E

Now Column E contains values in some rows that comes from column A

or we can say that Column E parent column is A.

So, how can we link or make a relationship in both the columns.

Re: How Can I link 2 Columns in a Same Table

Vikash — Sun, 25 Jul 2021 10:37:37 GMT

Hi Naman,

You can achieve this by using Self Join. Try the below script-

Temp:
LOAD * INLINE [
Employee_ID, Name, Gender, Manager_ID
1, Cheri, Agender, 2
2, Golda, Bigender, 3
3, Hermina, Female, 6
4, Leoine, Genderfluid, 8
5, Marcelle, Genderqueer, 9
6, Marsiella, Male, 10
7, Michelina, Non-binary, 1
8, Rhianon, Polygender, 11
9, Ric, Male, 12
10, Vicki, Bigender, 13
];

Left Join(Temp)
Load
Employee_ID as Manager_ID,
Name as Manager_Name
resident Temp;

Hope this helps.

Regards,

Re: How Can I link 2 Columns in a Same Table

Gonzales36 — Mon, 02 Aug 2021 06:11:29 GMT

We have been using this for several weeks now and it seems to be going nicely.

MyGroundBiz