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?
mannerism
Highly Voted 2 years, 6 months agoMirianeAn
Most Recent 4 weeks, 1 day agoKbo05
1 month, 1 week agoIron_Jade
1 month, 4 weeks agoHosna2023
2 months agoraavilam
2 months, 4 weeks agolucasnatanael93
2 months, 4 weeks agoHoooota
3 months, 3 weeks agoThandaPanda11
5 months agoDexTorao
5 months, 1 week agomv79
5 months, 2 weeks agoChopChop007
7 months, 1 week agorcaliandro
8 months, 3 weeks agoKiran37
9 months, 1 week agoNishi_06
9 months, 3 weeks agoGrey_Head
11 months, 4 weeks agoRoh1410
1 year, 3 months ago