Hello,
I'm facing with an annoying issue with power query sorting action.
Seems Power query sorting manage differently the special chars than Exel in the sort.
LEt me explain with a basic example :
I have a table with the basic following values, unsorted
Col1
val1
¨val1
_val1
If in Excel I sort ascending the table by Col1, result is :
Col1
_val1
¨val1
val1
and it is the result I expect.
If these data are now in power query, I execute the sort in power query with Table.Sort instruction and load data to workbook
the result is now :
Col1
_val1
val1
¨val1
You can find attached the workbook
So the Excel sorting is different from the Powerquery sorting, which cause some issues for me
Any idea on how I can use power query and having the excel sorting behavior ?
The single workaround found is to create a macro that refresh power query table, and after sort the result in excel
Thank you for your help.
I'm facing with an annoying issue with power query sorting action.
Seems Power query sorting manage differently the special chars than Exel in the sort.
LEt me explain with a basic example :
I have a table with the basic following values, unsorted
Col1
val1
¨val1
_val1
If in Excel I sort ascending the table by Col1, result is :
Col1
_val1
¨val1
val1
and it is the result I expect.
If these data are now in power query, I execute the sort in power query with Table.Sort instruction and load data to workbook
the result is now :
Col1
_val1
val1
¨val1
You can find attached the workbook
So the Excel sorting is different from the Powerquery sorting, which cause some issues for me
Any idea on how I can use power query and having the excel sorting behavior ?
The single workaround found is to create a macro that refresh power query table, and after sort the result in excel
Thank you for your help.