Forum Discussion

rmieszko's avatar
rmieszko
Frequent Visitor
7 years ago
Solved

Assignment based on column from different table

Hi,   I've got one table with groups and low-level teams: Group1 Group2 Group3 Group4 A D I M B E J N C F K     G L     H       In a different table I've g...
Need Help
  • CR's avatar
    CR
    7 years ago

    Hi rmieszko

     

    I advise you to open your Query Editor then to unpivot all the columns of your table 1.

     

     

    You will also get that:

     

     

    You also will able to use the function Merge Queries to get the data you need in your other table.

     

    Regards,

    CR

  • CR's avatar
    CR
    7 years ago

    for the merge queries, here are the steps:

     

     

    Then you select only Attribute

     

     

    Regards,

    CR

     

     

CR's avatar
CR
Resolver II
7 years ago

Hi rmieszko

 

I advise you to open your Query Editor then to unpivot all the columns of your table 1.

 

 

You will also get that:

 

 

You also will able to use the function Merge Queries to get the data you need in your other table.

 

Regards,

CR

  • CR's avatar
    CR
    Resolver II
    7 years ago

    for the merge queries, here are the steps:

     

     

    Then you select only Attribute

     

     

    Regards,

    CR

     

     

    • rmieszko's avatar
      rmieszko
      Frequent Visitor
      7 years ago

      I guess it's good idea :-) I will check this on Monday and let you know. Thank you!