Blending 4 files

[Simona]

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 

[N_Stout]

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!

[sam8]

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

[Mehdi_Oudjida]

@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-d...

I hope it helps.

Mehdi

[sam8]

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