cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FilipM Regular Visitor
Regular Visitor

invalid relationship for tables that should be many-to-one

Hi there,

 

I am trying to concenate two columns from two different tables. One column (assume table "A") is the week of year and another one is working place in the factory. What I would like to do, is connect the table with working place in the factory which has unique values with the column in table "A" that uses the same values but they are repeated. Hence, I assume I want to have many-to-one relationship.

Untitled.png

 

 

Thank you for the inputs.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: invalid relationship for tables that should be many-to-one

HI @FilipM ,

You can consider to create a calculated table to extract unique value from these table and use it as bridge table to link two tables.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
1 REPLY 1
Community Support Team
Community Support Team

Re: invalid relationship for tables that should be many-to-one

HI @FilipM ,

You can consider to create a calculated table to extract unique value from these table and use it as bridge table to link two tables.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |