{/* Content imported from WordPress - review and enhance */}
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
https://dev3lop.com/et1s-joiner-node/
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 (, , ,,“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.