How do I combine two datasets from two different Google sheets into the same table

[CCgoh]

Hi all, how do I combine two datasets together (they are with the same exact columns) we just split them into the active database and an archived database. For analysis purposes we need to combine two tables together to get a better snapshot. How do I do that in Google studio?

The number of rows are too large hence the usual sheets merge or import range doesnt work. 

[kdimitrof]

Hi there,
I would suggest to create UNION in a new data sources with the logic you need. Then to connect this data source in Looker Studio. 

There is a workaround with data blend but it is quite not intuitive (hope Union will be added one day in Looker Studio)

Kind regards,
Krassi

[Mehdi_Oudjida]

@CCgoh 

If you need to mimic a UNION ALL in Looker Studio, here an article describing how to with data blending.

https://how.withlookerstudio.com/data-sources/20220222-how-to-mimic-union-all-operator-with-google-d...

I hope it helps.

Mehdi

[Anneloes]

Filters do not work with the FULL OUTER JOIN and COALESCE solution. Does anybody know how to make them work?