Looker - Data Combination

Guys, 

I wonder if there is some way resource to blend data sources as a new register above below, instead of side.
It's my first time searching for help here, I don't if get clearly. 
I want to do like a Crtl-C and Crtl-V between two or more data sources without putting in just one. 

Thanks in advance for the attention. 

Solved Solved
0 3 185
1 ACCEPTED SOLUTION

It sounds like what you are looking to do is similar to UNION ALL in SQL...two different sources with the same structure, stacked one on top of each other. Unfortunately there isn't a built-in way to do this with Looker Studio, although @Mehdi_Oudjida has a hack that may work for you: https://www.withlookerstudio.com/blog/data-sources/20220222-how-to-mimic-union-all-operator-with-goo...

View solution in original post

3 REPLIES 3

It sounds like what you are looking to do is similar to UNION ALL in SQL...two different sources with the same structure, stacked one on top of each other. Unfortunately there isn't a built-in way to do this with Looker Studio, although @Mehdi_Oudjida has a hack that may work for you: https://www.withlookerstudio.com/blog/data-sources/20220222-how-to-mimic-union-all-operator-with-goo...

I took a quick look and that's I'm looking for. 
Thank you so much, @lauratilton .

Mehdi's hack is useful, but has some limitations (e.g. filters don't work in quite the same way, AFAIK).

There's an open feature request for UNIONs to be properly added to blend options (see https://issuetracker.google.com/issues/119886983 ) - upvote if this would be useful to you