Forum Discussion

StephenGW's avatar
StephenGW
Icon for Helper II rankHelper II
5 years ago
Solved

Mixed 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 ...
  • BA_Pete's avatar
    BA_Pete
    5 years ago

    StephenGW 

     

    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