PL-300 · Question #296
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 A. Merge the Customer and Address tables. A merge queries operation joins two existing tables together based on matching values from one or multiple columns. You can choose to use different types of joins, depending on the output you https://docs.microsoft.com/en-us/power-query/merge-queries-overview
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 in 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?
Exhibit
Options
- AMerge the Customer and Address tables.
- BGroup the Customer and Address tables by the Address ID column.
- CTranspose the Customer and Address tables.
- DAppend the Customer and Address tables.
How the community answered
(22 responses)- A82% (18)
- B5% (1)
- C5% (1)
- D9% (2)
Explanation
A merge queries operation joins two existing tables together based on matching values from one or multiple columns. You can choose to use different types of joins, depending on the output you https://docs.microsoft.com/en-us/power-query/merge-queries-overview
Community Discussion
No community discussion yet for this question.