Hi Daniel,

Great use-case!

Ideally, you would have an append/union operator, which would let you append two GQI results in a single table. After that, you would be able to apply an additional aggregate operator to take the sum. This is currently not yet possible, we have an item on our backlog to support this.

As a workaround you could do the following:

1. Add a new column to both query results, with both results having the same value in that new column ('Key' column in example). For that you can use a column manipulation operator with the concatenate method.
2. Join both tables together, where the newly created columns should match. For this you can use the join operator with the inner join type.
3. Apply a custom operator that calculates the sum of both sums. We have a custom operator on the Catalog that takes the sum of multiple columns: https://catalog.dataminer.services/details/package/5542 (Github), if you are Cloud-connected you can just hit deploy and the operator will show up under Apply custom operator.

Full example:

Hope this helps, let me know if anything is unclear!

Best regards, Ward