Forum Discussion

msantillan's avatar
msantillan
Icon for Helper II rankHelper II
6 years ago
Solved

Replace "null" values from ALL columns into null values Power Query

Hi, is there a way to replace values with "null" from ALL columns into NULL or Blank values in M query?   Something like this but applied to all of the columns:   Table.ReplaceValue(Source,"null"...
Need Help
  • ibarrau's avatar
    ibarrau
    6 years ago

    Hi. Yes you can. Try something like this:

    = Table.ReplaceValue(Source,"",null,Replacer.ReplaceValue, Table.ColumnNames(#"Step with all colums") )

    You can list the columns of one step in order to do the change. This will replace "" (blanks) with null.

     

    Regards,

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi msantillan ,

     

    Press Ctrl+A select all column and right the table then use replace value feature.

    You can check the query through Advance Editor feature.

     

    Best Regards,

    Jay

     

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
6 years ago

Hi. Yes you can. Try something like this:

= Table.ReplaceValue(Source,"",null,Replacer.ReplaceValue, Table.ColumnNames(#"Step with all colums") )

You can list the columns of one step in order to do the change. This will replace "" (blanks) with null.

 

Regards,