See also
Lookup (Merge columns template)
Union (Merging rows template)
Join (Merge columns, One-to-One demo template)
Join (Merge columns, one-to-many template)
Tags
solution
feature
08 Jun 2024 02:54 AM
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