--- title: Data Blending in Looker Studio Made Easy description: Dataddo offers a workaround that enables any business professional to overcome the blending limitations of Google Data Studio/Looker Studio. image: https://blog.dataddo.com/hubfs/data%20blending.jpg --- [![Dataddo Blog](https://blog.dataddo.com/hs-fs/hubfs/blog-logo.png?width=180&name=blog-logo.png)](https://blog.dataddo.com) ** [Get Dataddo Free](https://www.dataddo.com/signup?hsLang=en) [![Start for Free](https://no-cache.hubspot.com/cta/default/7885580/42e092dc-d403-4ac3-bd34-06dc490bf6d9.png)](https://cta-redirect.hubspot.com/cta/redirect/7885580/42e092dc-d403-4ac3-bd34-06dc490bf6d9) # Data Blending in Looker Studio Made Easy By Petr Nemeth | 5 min read ![](https://blog.dataddo.com/hubfs/data%20blending.jpg) - ** - ** - ** Looker Studio is great for data visualization and offers some transformation capability via in-built functions, but it is unable to perform advanced data manipulations such as data joining. Although it *does* offer data blending functionality, the functionality is rather difficult to set up and debug. Here is a workaround using Dataddo, which allows users to easily and without coding perform various joining operations (e.g. left join, right join, inner join) before sending data to Looker Studio. This gives users much more visualization flexibility. ## **Want more Looker Studio tips & tricks?** 1. [**Learn how to work with multiple date ranges.**](https://blog.dataddo.com/multiple-date-ranges-one-data-studio-table-a-how-to-guide?hsLang=en) 2. [**Get 3 free dashboard templates for beginners.**](https://blog.dataddo.com/3-beautiful-free-google-data-studio-dashboard-templates-for-beginners?hsLang=en) 3. [**Find out how to track your Instagram follower count.**](https://blog.dataddo.com/how-to-track-your-instagram-follower-count?hsLang=en) 4. **[Learn how to calculate weighted averages.](https://blog.dataddo.com/how-to-calculate-weighted-averages-in-google-data-studio?hsLang=en)** --- Step 1. [Log into the Dataddo platform ](https://app.dataddo.com/sign-in)and click on Flows at the top of the page. - **NOTE:** If you don't have an account, sign up for a [14-day free trial](https://www.dataddo.com/signup?hsLang=en). Step 2. Click on **Create Flow** in the top right corner. Step 3. Click on **Add Source** to connect it to the destination. You can type the connector's name into the search bar to find it faster. ![Add source to flow](https://blog.dataddo.com/hs-fs/hubfs/My%20Flows%20-%20New%20Flow.png?width=2880&name=My%20Flows%20-%20New%20Flow.png) Step 4. Click on **Blend Sources.** **![Choose first source to blend](https://blog.dataddo.com/hs-fs/hubfs/Data%20blending%20in%20app%20-%20step%204.png?width=2880&name=Data%20blending%20in%20app%20-%20step%204.png)** **Step 5**. Click on **Select Source** to choose the sources you wish to blend. ![Data blending in app - step 5](https://blog.dataddo.com/hs-fs/hubfs/Knowledge%20Base/Data%20Blending%20-%20general/Data%20blending%20in%20app%20-%20step%205.png?width=2880&name=Data%20blending%20in%20app%20-%20step%205.png) ![Add second source to blend](https://blog.dataddo.com/hs-fs/hubfs/Data%20blending%20in%20app%20-%20step%206.png?width=2880&name=Data%20blending%20in%20app%20-%20step%206.png) Step 6. Choose a **Join Key** that is the same for both sources. Dataddo will blend the datasets based on this particular key. You can select other columns for each source by dragging the fields from the list on the left or right. The columns do not need to be the same for each source. ![Data blending in app - step 7](https://blog.dataddo.com/hs-fs/hubfs/Knowledge%20Base/Data%20Blending%20-%20general/Data%20blending%20in%20app%20-%20step%207.png?width=2880&name=Data%20blending%20in%20app%20-%20step%207.png) Step 7. Click on the **button between the sources** to configure the joining type. By default, Left Join is selected. - **Left Join** - records from the right source will be joined **to the left** dataset. - **Right Join** - records from the left source will be joined **to the right** dataset. - **Inner Join -** returns only records whose values match in both column sources. ![Options to join sources](https://blog.dataddo.com/hs-fs/hubfs/Data%20blending%20in%20app%20-%20step%208.png?width=2880&name=Data%20blending%20in%20app%20-%20step%208.png) Step 8. Click on **Save Source**. Step 9. Once the data is configured for blending, you can **Add Destination**. ![Add destination](https://blog.dataddo.com/hs-fs/hubfs/Knowledge%20Base/Data%20Blending%20-%20general/Data%20blending%20in%20app%20-%20step%209.png?width=2880&name=Data%20blending%20in%20app%20-%20step%209.png) To set up the destination, choose the write mode and other necessary settings. You can also name the flow at the top. ![Set up your destination](https://blog.dataddo.com/hs-fs/hubfs/Data%20blending%20in%20app%20-%20step%2010.png?width=2880&name=Data%20blending%20in%20app%20-%20step%2010.png) Step 10. By clicking on **Data Preview,** you can check what data will be sent to the destination. The preview has a limit of approximately 100 rows. Click on **Save Flow**. ![Preview data](https://blog.dataddo.com/hs-fs/hubfs/Data%20blending%20in%20app%20-%20step%2011.png?width=2880&name=Data%20blending%20in%20app%20-%20step%2011.png) Step 11. Under the Flows tab, click Config and copy the API key and API endpoint ID into Looker Studio to complete synchronization. ![Get API for Google Data Studio](https://blog.dataddo.com/hs-fs/hubfs/Knowledge%20Base/Data%20Flow%20-%20Google%20Studio/Google%20Data%20Studio-%20Flow%20configuration%201.png?width=2880&name=Google%20Data%20Studio-%20Flow%20configuration%201.png) The above functionality is important because it enables any business professional to overcome the blending limitations of Looker Studio. |   **See how Dataddo can help your business** In just a few quick steps, get your data to Looker Studio or any other dashboarding app. [![Start for Free](https://no-cache.hubspot.com/cta/default/7885580/7ed5acf0-8674-4253-bada-90465ddc6f8a.png)](https://cta-redirect.hubspot.com/cta/redirect/7885580/7ed5acf0-8674-4253-bada-90465ddc6f8a)   | | --- | Category: [Product](https://blog.dataddo.com/tag/product), [tips-tricks](https://blog.dataddo.com/tag/tips-tricks) ### Related Articles** ## [Databox now supported for easy data visualization](https://blog.dataddo.com/databox-new-visualization-destination?hsLang=en) *(5 min read )* Topics: [Product](https://blog.dataddo.com/tag/product), [tips-tricks](https://blog.dataddo.com/tag/tips-tricks) ## [Dataddo Now Connects to Microsoft Fabric](https://blog.dataddo.com/dataddo-now-connects-to-microsoft-fabric?hsLang=en) *(5 min read )* Topics: [Product](https://blog.dataddo.com/tag/product), [tips-tricks](https://blog.dataddo.com/tag/tips-tricks) ## [Never Lose a Byte: When and Why to Use Full Data Re-Sync](https://blog.dataddo.com/never-lose-a-byte-when-and-why-to-use-full-data-re-sync?hsLang=en) *(5 min read )* Topics: [Product](https://blog.dataddo.com/tag/product), [tips-tricks](https://blog.dataddo.com/tag/tips-tricks) ### Subscribe to The Chronicles of Marketing Newsletter ## Comments ## Subscribe to Our Blog Stay up to date with the latest marketing, sales, and service tips and news. ![subscribe](https://blog.dataddo.com/hubfs/Illustrations/subscribe.svg) - [****](https://www.linkedin.com/company/dataddo) - © Dataddo, Inc. All Rights Reserved ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Petr Nemeth", "url" : "https://blog.dataddo.com/author/petr-nemeth" }, "dateModified" : "2024-05-24T09:17:23.559Z", "datePublished" : "2022-06-23T21:59:33.000Z", "headline" : "Data Blending in Looker Studio Made Easy", "image" : [ "https://blog.dataddo.com/hubfs/data%20blending.jpg" ], "mainEntityOfPage" : { "@id" : "https://blog.dataddo.com/data-blending-in-google-data-studio-made-easy", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://blog.dataddo.com/hubfs/Dark%20logo@3x-1.png" }, "name" : "Dataddo, Inc." } } ```