Notifications
Clear all
Topic starter
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?
- A . Merge the Customer and Address tables.
B. Transpose the Customer and Address tables.
C. Group the Customer and Address tables by the Address ID column.
D. Append the Customer and Address tables.
Suggested Answer: A
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 queries.
✑ When you have additional rows of data that you’d like to add to an existing query, you append the query.
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
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 queries.
✑ When you have additional rows of data that you’d like to add to an existing query, you append the query.
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
Posted : 10/02/2023 11:43 pm