Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Join a calculated table with an 'original' table

Hi all,    I am trying to combine a calculated table with an 'original' table.    Table A holds transactions per row. Each transaction is to be allocated to multiple customers the breakdown of sh...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    Because Table B is a calculated table, and it won't be displayed in Query Editor, so you might not use the Merge feature to combine the two tables into one.

     

    As a workaround, you can create relationship between the two tables on field [CLIENT GROUP], then put all the desired fields into the same table visual.

     

    Or you may include the Table A in the formula which created the calculated Table B.

     

    Best Regards,

    Amy

     

    Community Support Team _ Amy

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

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Because Table B is a calculated table, and it won't be displayed in Query Editor, so you might not use the Merge feature to combine the two tables into one.

 

As a workaround, you can create relationship between the two tables on field [CLIENT GROUP], then put all the desired fields into the same table visual.

 

Or you may include the Table A in the formula which created the calculated Table B.

 

Best Regards,

Amy

 

Community Support Team _ Amy

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