Forum Discussion
sort zero length text strig power query v excel
They are different programs with different sorting algorithms. As to why they were designed differently with regard to zero-width characters, you would have to discuss that with the teams that developed the two different programs. There are other parameters that are also sorted differently by those two programs.
i was not interested in a fix i the question was why does it treat them differently,
especially as i as i said you do the whole thing in excel it sort longest to shortes ie a -z, ,
power query also sorts a-z , i know im' repeatign mysielf, but if you load the power query to excel,
it then needs to be sorted z -a , why does this happent?
They are different programs with different sorting algorithms. As to why they were designed differently with regard to zero-width characters, you would have to discuss that with the teams that developed the two different programs. There are other parameters that are also sorted differently by those two programs.
Thanks, also, i've been doing a bit of digging for info, also been playing around, loading from xl, and pq,
into pivots, these seem to behave like power query ? is this correct,I haven't done that type of comparison.
Do you have a use case you need to resolve? Or is this an exploration of the different sorting algorithms being used?
I would expect that Excel and Excel generated pivot tables would sort the same (but, as I wrote, I've never tested it). I don't know about pivot tables generated through Power Pivot, though.
No, it's not a problem, I just thought it interesting in how they each treated, zero text as at
first i thought i was doing something different to cause it but it but i wasn't.