Split column by delimiter, can't convert to number

[Anonymous]

Hi there,

Despite changing all fields to text, I am getting a "can't convert to number" error after splitting a column into rows by a semicolon delimiter. 

I've tried to isolate the problematic rows by adding a keep errors step but it shows none and instead only shows the "can't convert to number" error.

Any help would be greatly appreciated.

Thanks!

[v-eqin-msft]

Hi @Anonymous ,

Could you tell me if my post helps you a little? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Hope to hear from you😀

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @Anonymous ,

The error message occurs when you try to convert Text or another data type to Int type.

Any transformations to your data will show in the Applied Steps list ,so you need to check it to find the error step.

Refer to :

https://docs.microsoft.com/en-us/power-query/applied-steps

https://docs.microsoft.com/en-us/power-query/dealing-with-errors

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ChrisMendoza]

Can you provide some data for us? 👀 How to Get Your Question Answered Quickly

[Anonymous]

Perhaps though the data is coming from a number of merges and there are about 20 steps prior to the error.

Is there a simple way this could be done?