Home » The Data Studio Blog » How to mimic UNION ALL operator with Data Studio (ex Looker Studio) and combine sets of data

How to mimic UNION ALL operator with Data Studio (ex Looker Studio) and combine sets of data

How to mimic union all operator with Data Studio and merge sets of data

Last week, we enjoyed discovering the new possibilities of data manipulation inside Data Studio (formerly known as Looker Studio), thanks to the new data blending features.

Now, it is time for a first tip to leverage them and built an operator not yet available : UNION, and more specifically, UNION ALL operator.


UNION ALL operator combines several sets of data with the same sequence of fields and the same related data types. Data sets can be made from separate data sources or from the same one just for filtering purposes.

It is quite common to use UNION operator in SQL to merge several sub queries, doing what is necessary to normalize the data schema across sources.

If you are familiar with SQL, you will see that inside Data Studio, the difference between UNION (removing duplicate rows) and UNION ALL (keeping all rows) operators will not be really significant because of the way we use dimensions and metrics aggregation options. In other words, distinct dimension values and sum of metric values are everywhere in Data Studio charts and we need to do specific things to avoid it…so, the opposite comparing to SQL queries…

For this article, I will use two examples applying the same trick:

  • Google Search Console with site data from web, image and video properties, combined in the same chart
  • Google Sheets to reproduce the mechanism of configuration with a simple example

For this tutorial, we will use table chart as the final result for both examples, but of course, you will be able to reproduce it for any chart type.

Unlock free access to the full article

Access to this article written by Mehdi Oudjida, Data Studio Expert, is completely free: enter your email address to receive an access link to the full article.

Your email address is only used to send the link, and for the newsletter if you tick the box. It is not stored on this site.

About The Author

Scroll to Top