Excel Power Query Merge

Hi. I am trying to merge two queries that I pulled from SQL using the
Merge function as shown below, but the "OK" button is not enabled.
I am not sure what I need to do to enable it.

1
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Pratima PharandeConnect With a Mentor Commented:
1.In the Merge dialog box:
a.Select the primary table from the upper drop-down list, and then select a column by clicking the column header.
b.Select the related table from the lower drop-down list, and then select a matching column by clicking the column header.
 
You need to select a matching column by clicking the column header.
then OK button on

Please refer below link to get details about how to use this Merge functionality
http://office.microsoft.com/en-in/excel-help/merge-queries-HA104149757.aspx?CTT=5&origin=HA103993872

Let me know if still issue persists
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.