Forum Discussion
nayanpatel
1 year agoNew Member
Data from table using relationship are not populated
Hi Friends, I have 3 tables related as Table1-->Table2-->Table3. Now, I need column from Table1 into Table3 (No Joins or merging). I need in front end. I Tried with Related and lookupvalue, but its ...
Anonymous
1 year agoNot applicable
Hi nayanpatel ,
You can try formula like below to create calculated column:
NewColumn = RELATED(Table1[Name])NewColumn_ = LOOKUPVALUE(Table1[Name], Table1[ID], Table3[Table2_ID])
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- nayanpatel1 year agoNew Member
HI, Thank you for the response !
What if there is no relationship between table and we need to bring value from Table1 to table2 based on Matching Key.