I have 2 sources: Data (Excel spreadsheet) and item_info (SQL table). They both share a field item_no. I want to join on this field in Data to bring in additional fields from the item_info table into Data.
Both fields are data type text.
There are no leading or trailing spaces.
Join kind is left outer (all from Data, matching from item_info)
I'm getting 0 matches.
If I open Data as a spreadsheet, and bring a query of item_info into a table in a spreadsheet, I can do a VLOOKUP on the field item_no and get results just fine.
Why won't the merge work in Power Query????
I don't have permission to attach a sample of the Data spreadsheet, maybe that would be helpful in identifying the issue?
Both fields are data type text.
There are no leading or trailing spaces.
Join kind is left outer (all from Data, matching from item_info)
I'm getting 0 matches.
If I open Data as a spreadsheet, and bring a query of item_info into a table in a spreadsheet, I can do a VLOOKUP on the field item_no and get results just fine.
Why won't the merge work in Power Query????
I don't have permission to attach a sample of the Data spreadsheet, maybe that would be helpful in identifying the issue?
