Blending 4 files

Looker Q&A Looker Studio
1

How do i blend 3 same files for 3 different year along with a file with product names to map these 4 tables together?

@All

2

Hi Simona,

Looker Studio allows for Blending of data. Blending data lets you create charts, tables, and controls based on multiple data sources. You can blend up to 5 tables.

Here is a helpful resource that outlines How Blending Data works!

3

It sounds like you need a UNION, not a blend. A blend only joins tables together horizontally, but it sounds like you want to add all three of these tables together vertically.

The UNION function is a feature request! Please add your feedback here: https://issuetracker.google.com/issues/119886983

4

@N_Stout

Meanwhile a native implementation, you can mimic UNION with a a blending trick I describe in this article.

https://how.withlookerstudio.com/data-sources/20220222-how-to-mimic-union-all-operator-with-google-data-studio-and-combine-sets-of-data/

I hope it helps.

Mehdi

2 Likes
5

This is really cool, @Mehdi_Oudjida ! Blending with full outer joins and then coalescing the nulls out, bravo. I hope this helps too!

1 Like