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:

Group1Group2Group3Group4
ADIM
BEJN
CFK 
 GL 
 H  

 

In a different table I've got tickets and and one of team {A, B, ..., N} assigned to it.

IDTeamGroup
1A 
2I 
3N 
4B 

 

What I need to do is fullfil Group column based on first table assigmnet. How to do this?

 

BR

Rafal

 

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

     

     

3 Replies

  • 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!