PL-300 · Question #102
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 correct answer is A. Merge the Customer and Address tables. There are two primary ways of combining queries: merging and appending. When you have one or more columns that you'd like to add to another query, you merge the When you have additional rows of data that you'd like to add to an existing query, you append the…
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 The Customer ID and Address ID columns represent unique rows. 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
- AMerge the Customer and Address tables.
- BTranspose the Customer and Address tables.
- CGroup the Customer and Address tables by the Address ID column.
- DAppend the Customer and Address tables.
How the community answered
(37 responses)- A89% (33)
- B3% (1)
- C3% (1)
- D5% (2)
Explanation
There are two primary ways of combining queries: merging and appending. When you have one or more columns that you'd like to add to another query, you merge the When you have additional rows of data that you'd like to add to an existing query, you append the https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
Topics
Community Discussion
No community discussion yet for this question.