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.

Anonymous's avatar
Anonymous
Not applicable
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.