Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Error in column

Hi,   I have a column formated as text with 2 types of data. 1) 12345 and 2) AB123. Now I am looking for a way to have them in same column without Error   thanks  
Need Help
AntrikshSharma's avatar
AntrikshSharma
Community Champion
3 years ago

Anonymous Then you can add a new column and use Value.FromText.

Table.AddColumn ( PreviousStep, "TextOrInt", each Value.FromText ( [Column] ), type any )
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

     

    • AntrikshSharma's avatar
      AntrikshSharma
      Community Champion
      3 years ago

      Anonymous Read the error! You are missing closing parenthesis and what is your previous step? use that in the first argument.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

         what they mean about PreviousStep?