PL-300 · Question #222
You import two Microsoft Excel tables named Customer and Address into Power Query Customer contains the following columns: - Customer ID - Customer Name - Phone - Email Address - Address ID Address…
The correct answer is D. Merge the Customer and Address tables. To combine columns from two tables based on a common identifier to get customer details including address information, you should merge the tables.
Question
You import two Microsoft Excel tables named Customer and Address into Power Query Customer contains the following columns:
- Customer ID
- Customer Name
- Phone
- Email Address
- Address ID
Address contains the following columns:
- Address ID
- Address Line 1
- Address Line 2
- City
- State/Region
- Country
- Postal Code
Each Customer ID represents a unique customer m the Customer table. Each Address ID represents a unique address in the Address table. You need to create a query that has one row per customer. Each row must contain City. State/Region, and Country for each customer. What should you do?
Options
- AAppend the Customer and Address tables.
- BTranspose the Customer and Address tables.
- CGroup the Customer and Address tables by the Address ID column.
- DMerge the Customer and Address tables.
How the community answered
(32 responses)- A3% (1)
- C3% (1)
- D94% (30)
Why each option
To combine columns from two tables based on a common identifier to get customer details including address information, you should merge the tables.
Appending tables combines rows from two tables vertically, which is used when tables have the same schema but different data rows, not for combining columns.
Transposing tables swaps rows and columns, which is a data transformation for restructuring, not for combining related information from separate tables.
Grouping tables aggregates data within a single table based on a column, creating summary rows, rather than combining data from two distinct tables.
Merging tables in Power Query combines columns from one table into another based on a shared column, such as 'Address ID', allowing you to associate address details (City, State/Region, Country) with each customer record. This operation is analogous to a SQL JOIN and is essential for enriching a primary table with related data from a secondary table.
Concept tested: Merging tables in Power Query
Source: https://learn.microsoft.com/en-us/power-query/merge-queries-overview
Topics
Community Discussion
No community discussion yet for this question.