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.
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)
