Forum Discussion
Merging queries - incorrect value after expand table
Hello, After merging 2 queries, I see that the value is correct and expected in the table view as below: But just after expanding tables I see different value (not match and incorrec...
Hello all,
I had the same.
In my case the reason was a step before merging: Sort ascending.
It seams like excel is having a bag whenever you sort the columns. The same is happening with the formulas in a table in a worksheet, if you sort in DESC or ASC order a randm column.
Once I removed the sorting, the merging was working properly.