Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Replace blanks with null

Dear friends   i need to fill down column but its cant because its not "null" how can i convert blank cell into null. thank in advance for any suggestions.      
Need Help
  • manikumar34's avatar
    manikumar34
    5 years ago

    Anonymous , 

    Use replace to achieve this. 

    Leave Value to Find as empty and replace with null. 

     

     

    In M-Query it looks something like below. 

    = Table.ReplaceValue(#"Replaced Value","",null,Replacer.ReplaceValue,{"COLUMN"})

     

    Try replacing the column name and add the above line in advanced editor else use the first step.

    Regards, '

    Manikumar

     

    If you find this is helpful, Accept as a Solution and leave a like.

manikumar34's avatar
manikumar34
Icon for Solution Sage rankSolution Sage
5 years ago

Anonymous , 

Use replace to achieve this. 

Leave Value to Find as empty and replace with null. 

 

 

In M-Query it looks something like below. 

= Table.ReplaceValue(#"Replaced Value","",null,Replacer.ReplaceValue,{"COLUMN"})

 

Try replacing the column name and add the above line in advanced editor else use the first step.

Regards, '

Manikumar

 

If you find this is helpful, Accept as a Solution and leave a like.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    thanks a lot manikumar34  its work!

  • BrewDoug's avatar
    BrewDoug
    New Member
    3 years ago

    I have an entire Datamart with all strings stored in "Not NULL" columns. (blanks). Is there a way to change this somewhere Database or Table wide instead of changing this value on each individual field?

    THanks for your help.