Forum Discussion
Solved
Create a calculated columns from 2 tables
Dear Community, I have these 2 tables: Table1 Table2 The relationship between tables is many-to-many with column Client My objective is to have two calculated columns in Table1 where ...
It's better version
We concatenate by two columns here
Source file: https://1drv.ms/u/s!AiNTN-Usixb7h9JTE5bZIVEGbQGfUQ?e=2PK2tO
Hi technolog, it works! thank you. I solved first part of the question. The second part is how to show the value in table2[ore] in a column that match client in table1. Can you help? Can I write the same formula?
Many Thx
Hi marabeda ,
I am very happy that your problem is solved, please mark it so that more people with the same problem as you can find the answer quickly!
Best Regards
Community Support Team _ chenwu zhu