• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 619
  • Last Modified:

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.

Murray Brown
Murray Brown
1 Solution
Pratima PharandeCommented:
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

Let me know if still issue persists
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
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.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now