Using Data Blend

Data Blend is a data sculpting tool that creates non-materialized views of your datasets. One way to think of a blend is a highly scalable equivalent of Excel's VLOOKUP function. Blends are useful when you want to do lookup translations on large tables in memory via a mapping table. Blends are also useful for appending (merging or performing a union) datasets into a single dataset. Blends are dataset definitions and, once saved, can be viewed in the dataset catalog. Blends can be created via the BLEND option on the Datasets page. Blends live in the Adrenaline cache, so they are in-memory fast.

Let's learn how to create a Data Blend.

Creating a Data Blend

Picking up from where we left off in the Creating a Data View section, let's use a blend to merge the Opportunity Leaders and Opportunity Laggards datasets into a single non-materialized dataset:

1. Click on the DATA item in the Domo main menu bar.
2. Click on Blend in the MAGIC TRANSFORM...