Linking two tables with multiple similar columns

[sagnikrana]

Hello Everyone,

Can anyone guide me on how to link these two tables ?

pivot_tree:

pivot_tree_helper_table

The expectation is -

when I select Task B in pivot tree table, the data model should select the correct task_id in the pivot_tree_helper_table

But I am unable to link the two tables

**I cannot add any new rows into the first table as it's being utilized by a pivot table. Although, I can add more columns.

*** I cannot break the pivot_tree_helper_table into smaller tables, as I need to link task_id  to further tables in my database. It will create circular reference.

Thanks!

Sagnik

[Alarkis]

Try

linking Name1 Name2 Name3 in both tables with a composite key

[sagnikrana]

It would be great if you could help me understand with an example.

Suppose the candidate key for 4th row in first table is ABC, then how I am supposed to connect it with other table in the runtime ? I will have the same candidate key for 3 rows.

Thanks!

Sagnik

[marcus_sommer]

I think I would load both tables with a crosstable-statement and then consider if it's better to concatenate both instead of linking them.

- Marcus