Forum Discussion
Power Query different results
Not at my laptop, but if you ue the UI to edit your query, there is a cogwheel on the MergedLevel2 step. Click it. There is a parameter there where you give a number for the fuzzyness of the match. 1 = exact match, lower is more fuzzy (IIRC). See here: https://learn.microsoft.com/en-us/powerquery-m/table-fuzzynestedjoin
This is what the docs say:
Threshold: A number between 0.00 and 1.00 that specifies the similarity score at which two values will be matched. For example, "Grapes" and "Graes" (missing the "p") are matched only if this option is set to less than 0.90. A threshold of 1.00 only allows exact matches. (Note that a fuzzy "exact match" might ignore differences like casing, word order, and punctuation.) The default value is 0.80
hello,
Here are the results:
So the first problem is at step " ExpandedLevel2"
// Step 5: Merge Level 2 with Level 1
MergedLevel2 = Table.FuzzyNestedJoin(Level2Result, {"Parent FWBSCode"}, Level1Result, {"FWBS code"}, "Level1", JoinKind.LeftOuter, [IgnoreCase=true, IgnoreSpace=true]),
ExpandedLevel2 = Table.ExpandTableColumn(MergedLevel2, "Level1", {"FWBS code", "FWBS description"}, {"SUP", "SUP_Description"}),during merging I suppose.
Thanks for your help
And Level2Result and Level1Result are identical on both computers?
It is a fuzzy match.... 100% sure the match paremetrs are identical on both computers? I am asking because that is normally the most likely cause.... You might want to try to give a explicit treshold value to see if that helps.
The powerquery versions are identical. The excel versions are unreadable, but I assume these match as well. So software differences seem unlikely...
And Level2Result and Level1Result are identical on both computers?Yes, they are
PwerQueryKees wrote:100% sure the match paremetrs are identical on both computers?
this is the same file, so yes
PwerQueryKees wrote:You might want to try to give a explicit treshold value to see if that helps.
Not sure what this mean.
And yes, same version for MS/Exel/PowerQuery