Merging Datasets

close

Available Building Blocks:

  • Union
  • Lookup
  • Join

Use Cases:

  • Merge rows: Union
  • Merge columns One-to-One: Lookup
  • Merge columns One-to-Many: Join

Lookup is a preferable way to merge columns. If you confused with results of Join please read the article on Join One-to-Many.

Business Cases:

  • Combine revenue data from CRM with cost data from advertising networks: suggested building blocks Lookup
  • Combine revenue data from CRM with cost data from advertising networks with goal to find ROAS of advertisement campaigns: suggested building blocks Join
  • Combine data from two advertising networks: suggested building blocks Union