Forum Discussion

Sweet-T's avatar
Sweet-T
Icon for Helper III rankHelper III
7 years ago
Solved

Merge columns, by comparing 2 criteria

Hi everyone,

 

I'd like to merge two queries together, by comparing 2 columns. Is this possible? If not, any suggestions for a suitable work-around? 

 

I have queries 'Quota' and 'Forecast'. I would like to merge 'Forecast' with 'Quota' when :

'Quota'[Territory] = 'Forecast'[Territory] && 'Quota'[Date] = 'Forecast'[Date]

Any help would be greatly appreciated. 

 

Thanks!

Theo

Need Help
  • MFelix's avatar
    MFelix
    7 years ago
    Hi Sweet-T,

    On the query editor if you selecf the merge tables on the column selector if you press CTRL and the columns you need it is possible to merge table by more than 1 column.

    Regards,
    MFelix

2 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    7 years ago
    Hi Sweet-T,

    On the query editor if you selecf the merge tables on the column selector if you press CTRL and the columns you need it is possible to merge table by more than 1 column.

    Regards,
    MFelix
    • Sweet-T's avatar
      Sweet-T
      Icon for Helper III rankHelper III
      7 years ago

      Can't believe I didn't try that. 


      Thanks very much!