Forum Discussion
Merge not Finding Matches Against Custom Column
Hi all,
I've searched up and down and not found any pertient results for my issue.
I've created a custom column that extracts three characters out of a text string. I'm think attempting to do a Merge Query using the Custom Column against a column in another table with the same strings. On the Merge PowerBI says the selection has failed to find any matches and if I do hit Ok I just get null values (which makes sense, since it can't find any matches). However, since I can look at the data I know for a fact I have matches.
I should also mention I did recast my custom column as text, as the column in the table I'm attempting to merge in is a Text column.
My data source is an MS-SQL DB.
Thanks for reading!
-Robert
If you convert to real numbers you will lose the leading zeros. I would keep it as text. Use trim, then clean, then transform to lowercase (even for the numbers) then try it again. I actually just ran into this issue and by cleaning the column first, it worked.
9 Replies
Anonymous - the character strings I'm looking to match are all numerals, so unless I'm missing something, it doesn't seem likely that is the issue...
There might be spaces, blanks or unprintable characters in them. I'd recommend to convert them to "real" number formats and then you should be fine.
