Free Preparation Discussions
MENU
Microsoft PL-300 Exam - Topic 1 Question 85 Discussion
Topic #: 1
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?
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.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
Currently there are no comments in this discussion, be the first to comment!