How Can I link 2 Columns in a Same Table

[Naman_Vyas]

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.

[Vikash]

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]

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

MyGroundBiz