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)})

     

AlienSx's avatar
AlienSx
Super User
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)})