Forum Discussion
StephenGW
Helper II
5 years agoMixed data type results in infinity
All, I have some data with some mixed data types. A column that is primarily a number but some of the numbers are like 03E5642 and that is trned into infinity. If I chage it to text data type it ...
- 5 years ago
Ok. What transformation steps have you applied to this table? Has the original data been converted to number, then to text, without overwriting the number change step? How does this field look when you select the source or navigation steps - are the infinity symbols already there?
Pete
BA_Pete
Super User
5 years ago
Ok. What transformation steps have you applied to this table? Has the original data been converted to number, then to text, without overwriting the number change step? How does this field look when you select the source or navigation steps - are the infinity symbols already there?
Pete