'2 elvers' error message

Hi tgjones43 ,

When you look at this error code you have the information of what is the transformation that is happening in this case formatting a value to number and the data that is being transformed "2 elves" this is composed by numbers and text so it cannot be formatted as number.

You need to go on a step that is should be called "Change Type" go to the previous step and on the column you are having this error select the text format, if it asks to replace the next step say yes.

When you have an error on the query all the steps after that will return error.

Regards,

MFelix

Hi tgjones43 ,

i think there is a "Changed Type" step, where you try to convert a column with text to number.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.