Forum Discussion

BatTodor's avatar
BatTodor
Frequent Visitor
8 years ago

Replace values to null

Hi, I want to replace all values in all selected columns to null. In general, main aim is to Fill down all cells with value, but at first need to clear all previous information. Is it possible? Best ...
BatTodor's avatar
BatTodor
Frequent Visitor
8 years ago

Hi v-frfei-msft,

Thanks a lot for support! :-)

When I use for one column, it's OK!

Unfortunately failed to implement dinamicaly solution. Tryed to use #"Table.TransformColumns" = Table.TransformColumns(PromotedHeaders, List.Transform(Columns, each {_, "null"})),

#"Table.TransformColumns" = Table.TransformColumns(previousstep, List.Transform(Columns, each {_, "null"})),

 where Columns is list of columns to replace.

 

Could be done?

 

Best regards

Todor

v-frfei-msft's avatar
v-frfei-msft
Community Support
8 years ago

Hi BatTodor,

 

Based on my test, here we can only replace the values one by one. We cannot replace all the values of column list.

 

 

Regards,

Frank