Forum Discussion

Nazdac911's avatar
Nazdac911
Helper II
3 years ago
Solved

In a List Columns , detect null values and replace them with a value

Hi all  I have a couple of columns that contains Lists formed as follow : [ item1, item2, null , item3, .... ]  those list values are connected to each others in different columns.  When trying to...
Need Help
  • AlienSx's avatar
    AlienSx
    3 years ago

    Hello, Nazdac911 

    to replace nulls in your columns with lists 

    = Table.TransformColumns(Source,{"col1", (x) => List.ReplaceValue( x, null, 0, Replacer.ReplaceValue)})

     

olgad's avatar
olgad
Resident Rockstar
3 years ago

Hi, go to your table, Press Ctrl+A, it will allow you to select all columns, the right click replace values,  then use replace value feature from null to 0.

Hope you it helps. 

  • Nazdac911's avatar
    Nazdac911
    Helper II
    3 years ago

    Sadly this is not working , values are not changing 
    Correction : data is represented curvy brakets : {1 , , 3 , 7 , 9 , , , , , 98 ,  , .....}
    thanks in advance 
    Regards