Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Replacing nulls with Error

Hi, I have a relatively simple problem to solve but can't find the solution anywhere. How can I replace null values in a particular column with Error values? Thanks!
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous 

 

If you literarily want to show "Error" this word

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

No I do not want to show Error as a string, I want to specify an error as the cell value........

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous 

     

    I am not sure why you want an error, but you can do like this, transform your current column

    Table.TransformColumns(yourPreviousStep,{{"yourColumn", each if _=null then Text.PositionOf(_,"a") else _}})