Forum Discussion
Solved
columns with mixed data types
Hi, I'm working with debtor/invoice data. One of my fields is "Account Number". Roughly 80% of these are numeric, however internal customer numbers have a letter prefixing the account number. ...
If you add an extra step to change number back to text, the errors won't be corrected, so you should adjust the autogenerated step in which the data types were changed and adjust "number" to "text" for the Account Number field.
If you add an extra step to change number back to text, the errors won't be corrected, so you should adjust the autogenerated step in which the data types were changed and adjust "number" to "text" for the Account Number field.
This did it thanks!
As you said, I went to the auto-generated steps where Power Query first decides on the data type of each field and changed the "Account" type to text. Sorted. Thankyou.