Hi, I’ve created a relation similar to the Employee Dictertory example but the relation is not returning the proper data. In addition to the columns found in Employee Dicterory example, I have added to 2 new columns Company Email (column A) and Company Name (column B). However, when I do the Manager relation it’s returning the Company email instead of the Name of the employee’s manager.
The relation column in the data tab is just going to show the first column from the related sheet. This is normal and the relation is still correct. If you are looking to return a particular column, from the related sheet, you will need to also create a Lookup column. The Lookup column uses the Relation to retrieve a specific column value from the related sheet.
1 Like
Okay thanks Jeff. I was confused.
1 Like
Hello,
is there a clear definition of what exact column the relation column returns? I thought it was the first one.
some of my data is not in English (Arabic).
Its a store and when creating a relation column in category table to return the products from the products table who are members of this category the column is returning the product description which is a column in the middle of my products table. I know its functioning correctly but it would be nice to understand how in order to make the tables look better and possibly return product ID or product name.
I don’t know how a relation column determines or is supposed to determine which column to show. Something changed a long time ago, but originally, it used to be the first column. It’s probably showing a certain column position, but if you move columns around, then it shows random columns. No idea. I don’t think about it much.
A relation column returns entire rows. Not single columns. So it makes no difference what it shows. It just lets you know that it found a match. To pull out individual columns from that relation, you use a Lookup column. So if you want to see a specific column value from the table the relation is referring to, then add a lookup column to see that value.
2 Likes
Closing due to inactivity. This topic will be deleted in a few weeks if there are no more comments.