Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Naman_Vyas
Partner
Partner

How Can I link 2 Columns in a Same Table

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.

 

2 Replies
Vikash
Contributor III
Contributor III

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,

VK

Gonzales36
Contributor
Contributor

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

 

MyGroundBiz