Log In
Register
Home
New Member
April 15, 2019
Offline
I was looking at the Power Query VLOOKUP page, and it seems to be what I was searching for. My issue is that the two columns that i'm merging are numbers, and the data that I actually want are text.
I have a table with subscriptions, which have a column with the customer ID for the customer. In another table I have all the customers with ID and Name. I want to merge the two CustID columns and then have Power Query show the customer name for me.
I have the subscriptions as my "data" table, and customers as my "Categories" table.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Mathias,
When merging 2 queries, you need to make sure that the key columns pairs have the same format( numeric, text, date and so on). For example, if ID is formatted as numeric on a table, cannot be formatted as text in the second query, it will return no match.
The result of the merge will be a table. By clicking the Expand button on the merged column, you will be able to select which columns you want to see from the second table/query, no need to select the columns used as keys for the merge, as you already have them displayed in the first table.
1 Guest(s)
