LookUpValues or RelatedTable

[enicolasAtmosp]

Hello,
I need your help please.

I can't use the lookUpValue or RelatedTable function to get information from another table.

I mean there is the 'Sales' table and the 'Obj' table and I would like to take from the 'Sales' table the column of smartphone models (string) and incorporate it in the 'Obj' table by using their IDs present in each table.

My data model

It displays this message: 

 

 

"A table of multiple values was supplied where a single value was expected"

 

[v-jingzhang]

Hi @enicolasAtmosp 

According to the error message, it found multiple smartphone model values for an ID in the Sales table. In your data, does an ID only have one smartphone model value or it may have multiple values? If it has multiple values, you will see this error.

Regards,
Community Support Team _ Jing

[enicolasAtmosp]

Hey Thank you for you help   After 4 different attempts, the only one which seems to work is : But, there is a mistake : in fact, some smartphone models are missing 

[amitchandak]

@enicolasAtmosp , depending  on the relation between tables there are 4 ways , refer to my video on that

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8