Forum Discussion
Replace multiple nulls at once in Power Query
MarcelBeug, this is much closer to what I had envisioned with some of the capabilities. I came across something similar to what I was thinking, but this was only to change a column header. It's just a step you add anywhere in your power query to transform the headers to a clean name, regardless of what's there. I think something like this is possible with the data types, but it might be a lot longer given the work needed for figuring out the Kind.
#"Alter Column Names" = Table.TransformColumnNames( #"<<<Previous Change Name>>>", ( columnName as text ) as text => Text.Combine( List.Transform( Text.Split( columnName, "_" ), each if Text.Length( _ ) >= 4 then Text.Proper( _ ) else _ ), " ") ),
Thanks for the thumbs up, but I'm really confused by your previous post.
Your question was about replacing null values, so what have column headers to do with that??
Is your initial question answered?
Is your previous post just a remark or a new question?
In the latter case you'd better mark this topic as answered and raise a new topic.
Motivation from solution above ... as I needed to replace null values in the whole table without specifying columns - modified a bit suggested formula:
= Table.ReplaceValue(Source,null,0,Replacer.ReplaceValue,Table.ColumnNames(Source))where Source - a reference to the data table.
many thanks for this. It helped me solve the exact same issue I was having.
