Frappe Insights - Union?

Hi, just a quick question. Does anyone know if Insights is capable of doing a Union of two queries (assuming they have the same columns)?

The use case is appending data from two tables together, possibly from separate sources, e.g. Sales A and Sales B.

From the documentation it seems the only way this might be possible is using manual SQL in the editor. Can you create manual queries using the Query Store as a source?

I have used Power BI/Query and it is flexible enough to allow any number of transformations and unions of tables from different sources to do just about anything you can think of.


@nextchamp.saqib we can add union support ig.

1 Like

It looks like a UNION can be mimicked using a FULL OUTER JOIN, so I imagine it is possible: