1. Merging Customer Orders
Data AnalystBackground
I have a 'Customers' table and an 'Orders' table, both containing a 'CustomerID' column.
Problem
I need to create a single report that links every order to the specific customer who placed it.
How to use
Paste both tables, select 'Left Join', and set 'CustomerID' as the key for both the left and right tables.
joinType: left, leftTableKey: CustomerID, rightTableKey: CustomerIDOutcome
A unified table containing all customer details alongside their corresponding order information.