Excel Power Query Merge Issue

Hi. I got the following result from merging the two queries further on using the PartID
as the common or primary column. I expected to see the Name column there too

1
2
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Pratima PharandeConnect With a Mentor Commented:
try this in previous link

1.In the Preview grid, click the NewColumn expand icon ( ).
2.In the Expand drop-down:
a.Click (Select All Columns) to clear all columns.
b.Click the columns from the related table to add to the primary table.
c.Click OK.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks
0
All Courses

From novice to tech pro — start learning today.