Are you combining the data? We have you covered. ET1 has all the right tools.
The Three Musketeers of Data Combination
1. 🤝 Join (The Matchmaker)
- What it does: Combines tables based on matching values
- Perfect for:
- Merging customer data with their orders
- Adding product details to sales records
- Any “this goes with that” scenario
- Inner join, left join, here is the tool.
- Automatically infer columns based on headers matching
2. 🔗 Union (The Stacker)
- What it does: Stacks datasets with the same structure
- Perfect for:
- Combining monthly reports
- Stacking related data files
- Merging similar datasets from different sources
- Creating master lists from multiple spreadsheets
3. 🧵 Concat ([bring], [it], [together],[with],”glue”)
Concat merges everything, and it doesn’t care about data types.
- What it does: Merges text from different columns
- Add a custom string between what you’re merging.
- Perfect for:
- Creating full names from first/last
- Building addresses from components
- Generating unique IDs or labels
- Bringing together: State with City in 1 column.
Real-World Examples
Join:
- Match customer emails with their support tickets
- Combine product IDs with inventory details
Union:
- Merge Q1, Q2, Q3 sales into one report
- Combine survey responses from different regions
Concat:
- Create “Last, First” name formats
- Build URLs from domain + path components
Pro Tips
- Joins work best with unique identifiers
- Union requires matching column structures
- Concat can add custom separators (spaces, dashes, etc.)
- Remove duplicate records
No more copy-pasting between spreadsheets or writing complex formulas – just connect the dots and let the data flow! No strange joining tools in Excel, no learning the difference between joins, and just get your data wrangled already!
Learn more about our app: ET1 overview page.
