I'm a frequent user of Power Query in Excel in Office 365
I have just created a query to retrieve certain columns from a workbook, one of which is an "APPID" code.
The workbook has over 4000 rows and the query successfully retrieves all of the information, apart from one code.
In the workbook the APPID code is 36471211000001100
In the query on that product the APPID code is 36471211000001104
Everything else on the row. i.e. description; price, etc matches to the original workbook; but the final digit is changed from a 0 to a 4.
Can anyone suggest a possible reason for this behaviour?
Bookmarks