Forum Discussion
Datatype
When im trying to change my datatype from ABC123 to whole numbers it doesnt work. There was a row with text there before but i replaced the data with 0. The query has been appended before so i tried ...
- Do your transformation to change from ABC123 to Integer.
- On the Home ribbon, select the Keep Rows dropdown and "Keep Errors"
- Put your cursor next to the word "error" (don't click on the word "error") and look at the yellow box at the bottom of the screen.
It will tell you why it is having trouble. You can then clean that up as well before you do the ABC123-Integer conversion. In my sample below I entered the text "aaa" in a column of numbers.
v-lid-msft
Community Support
Community SupportHi Anonymous ,
If the column has the same sub-String such as "ABC", we can use Table.ReplaceValue to remove it and then change it to whole number.
Best regards,