Hi @rvnth ,
Query1 394 and Query2 191, so there are 585 records in total.
When using 'keys only' you got 566 records, because 19 records are common in both queries set.
In order to get all 585 total records as output of Union, try the below steps,
In Query1 > add data > add an output column with a...