Forum Discussion

jja's avatar
jja
Helper III
2 years ago
Solved

Help create relationships on model

Hi I have folowing tables: What i want to do is on table new_components create a column and return linked Treatment value from related data tables.   new_treatment,new_ducttreatment and new...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  jja ,

    "in table new_components regarding Padengimas i have it in either 3 Separate columns(based on different Tipas)" is not very clear, but are you referring to three different [Tipas] in the new_components.

     

    You might consider using Power Query – select [Tipas] column - Unpivot Column – to turn it into a column.

    According to your description, table concat_treatment is a concatanated table of those 3 earlier mentioned tables, so you can use concat_treatment as a bridge table to connect the rest of the tables to this table via [Tipas].

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  jja ,

"in table new_components regarding Padengimas i have it in either 3 Separate columns(based on different Tipas)" is not very clear, but are you referring to three different [Tipas] in the new_components.

 

You might consider using Power Query – select [Tipas] column - Unpivot Column – to turn it into a column.

According to your description, table concat_treatment is a concatanated table of those 3 earlier mentioned tables, so you can use concat_treatment as a bridge table to connect the rest of the tables to this table via [Tipas].

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.