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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago
So if you are saying ALL COLUMNS and do not mean specifying each column individually, I'm not sure you can do that, but ImkeF or edhans would probably know for sure.
edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
6 years ago

ibarrau nailed it. That is the solution.

  • ImkeF's avatar
    ImkeF
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Like edhans said.

    The "#"Step with all colums" is probably "Source" here for your case.

    (It's mostly the first argument of the Table.ReplaceValue-function for these use cases)