Forum Discussion
mattymc1984
Advocate I
Advocate Icolumns 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.
MarcelBeug
Community Champion
Community ChampionIf 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.
mattymc1984This 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.