Forum Discussion
WillemM
Helper I
Helper IIssue merging and expanding afterwards
Hello, I'm experiencing an unexpected result in my Powerquery steps. Hope someone can help me understand what is happening or advice on what i'm doing wrong. The join-step gives exactly the right a...
Have you tried to do a Table.Buffer() before the join?
Buffer = Table.Buffer(#'Changed Type1')
You have to change the input table in merge step to the buffer aswell.
Chewdata
Responsive Resident
Responsive ResidentHey!
I see that your Statustypevolgnummer is datatype any, which means that it is treated as text. that means that with sorting 11 comes after 1. This might be the problem when adding the index and addition.
WillemMHelper I
Helper IHi,
Tried, but doesn't change the output.
- Chewdata
Have you tried to do a Table.Buffer() before the join?
Buffer = Table.Buffer(#'Changed Type1')
You have to change the input table in merge step to the buffer aswell.- WillemM
Hi Chewdata,
Thx. Inserting this step solved the issue. I will look further into this function to see/understand why/how this solved the issue.