Merge in PQE works but when I click table, it says table is empty

J

Jahmia0616

New Member
Joined
May 16, 2024
Messages
3
Office Version
  1. 365
Platform
  1. Windows
I have a contacts list from outlook that I need to merge with my funding list. I am trying to merge based off of comparing GroupName on the funding contacts tab and Company on the outlook contacts tab. When I merge, it shows there are matches but when I try to expand the data in the column that shows table 1, it says this table is empty. I tried changing the data type to text for both tables but that didnt work either. Can you let me know what else I can try to make sure the tables merge as expected?

Here is the link for the sample workbook: https://file.io/dk3dkmgI6Pj1
 

Attachments

  • Merge queries.png
    Merge queries.png
    49.2 KB · Views: 12
  • Merged query results.png
    Merged query results.png
    80.7 KB · Views: 12
  • Table 1 results.png
    Table 1 results.png
    39.2 KB · Views: 12

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Sort by date Sort by votes
Suggest you post to a different third party site. My Norton returns the following message.

BLOCKED BY

Dangerous Web Page Blocked
You attempted to access:
www.file.io

Deleted

Sharing files with file.io is convenient, anonymous and secure. Just upload files and share the links via email, SMS, Slack, Discord, etc. Easy-to-use REST API.
www.file.io
This is a known dangerous webpage. It is highly recommended that you do NOT visit this page.
 
Upvote 1
there is no single match between groupname and company. you can verify it using vlookup function.
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Question
PowerBI - Linked sources - splicer not working - expanded rows
Replies
0
Views
245
Tashat
T
S
  • Question
Table.Expand duplicates some Files when using folder connect? Tried everything I know.
Replies
1
Views
188
GraH
GraH
K
  • Question
What Tool Can I Use To Add/Delete Current Data Vs Previous Data
Replies
4
Views
528
kraamerica
K
J
  • Question
"Expression.Error: There weren't enough elements in the enumeration to complete the operation." when expanding nested table
Replies
2
Views
7K
Jinxster
J
gheyman
  • Question
Power Query: I need to add a column to a table that has the value from another table
Replies
6
Views
2K
jaeiow
J

Forum statistics

Threads
1,216,499
Messages
6,131,012
Members
449,613
Latest member
MedDash99

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top