Merging Datasets

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