Forum Discussion

Dom87326's avatar
Dom87326
Helper II
4 years ago
Solved

Table.ReplaceValue

Hello Experts,    I'm trying to replace values - to blank or null in a columns using: = Table.ReplaceValue(#"Renamed ColumnsY",Number.FromText("-"), null,Replacer.ReplaceValue,{"ColumnX"})    ...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Don't use Number.FromText("-"). Since you are trying to replace "-" with null, hence Number.FromText is not needed. This will give error as "-" can't be identified as number.

    Use below

    = Table.ReplaceValue(#"Renamed ColumnsY","-",null,Replacer.ReplaceValue,{"ColumnX"})
  • Dom87326's avatar
    Dom87326
    4 years ago

    Yes, and then I could use Replace Errors instead. Thanks!

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Don't use Number.FromText("-"). Since you are trying to replace "-" with null, hence Number.FromText is not needed. This will give error as "-" can't be identified as number.

Use below

= Table.ReplaceValue(#"Renamed ColumnsY","-",null,Replacer.ReplaceValue,{"ColumnX"})
  • Dom87326's avatar
    Dom87326
    Helper II
    4 years ago

    Yes, and then I could use Replace Errors instead. Thanks!