Looker Studio Blend that Stacks Data, like query does in google sheets?

[Tschaffe8]

HI All, 

I am trying to stack two sheets of data together in looker studio. One sheet is an archive sheet and one is new entries. They have the same column headers but no matching primary keys (they move the rows to archive sheet after two months) I was able to stack the data back together in google sheets using =query, but the data set is so large that it times out google sheets often. I am trying to query and join it via looker for more flexibility. 

I added a dummy variable on both (just the number 1), and joined them as an inner join. If I wanted to just combine the data sources on top of each other, how would I configure the join?

Thanks! 

[sam8]

Sounds like you're looking for a UNION. 

This is technically a feature request, but I will share a workaround I've come across.