Forum Discussion
Expression.Error: We cannot convert the value null to type Number. mysteriously appeared
OK, I finally managed to solve this issue. Error message was in the end misleading.
The error "Expression.Error: We cannot convert the value null to type Number" happened already in earlier steps. For some reason it got expanded to all the columns at the later steps.
The root cause was unexpected values in the code list merged in earlier steps.
None of this worked for me. Try this:
1. Find the step tranformation step where this error start appearing.
2. go to one step above that (a point where the error does not exist)
3. Select all columns and click "Remove Errors"
4. Go to the next step and the error should be gone.
This seem to work for my transformations.
That worked for me. This step of removing errors before the point of error has resolved the issue of
Expression.Error: We cannot convert the value null to type NumberThanks a lot
