Skip to main contentCombine data across multiple files to answer more complex questions.
When You Need Multi-Table Analysis
Use multi-table analysis when:
- Data is split across files
- You need context from another dataset
- One file references another (IDs, names, categories)
Examples:
- Orders + Customers
- Transactions + Products
- Events + Users
How Zark Connects Tables
Zark automatically detects shared fields and uses column names and values to infer relationships. When the connection is ambiguous, you can specify:
- “Join customers and orders on customer_id”
Common Use Cases
- Revenue by customer segment
- Orders enriched with product category
- Customers without transactions
- Mismatched or missing relationships
Examples:
- “Join the customer table with the orders table and show total revenue per customer”
- “Show order revenue by customer segment”
- “Show me customers who appear in the CRM but not in the billing system”
Explicit Joins
When automatic detection isn’t enough, you can specify:
- Join key
- Join type
- Inclusion logic
Example:
- “Join users and subscriptions where user_id matches”
- “Join these tables on the email column, keeping only records that appear in both”
