Forum Discussion

Helper IV

5 years ago

Solved

Unable to replace null values in one column ?

Hi there, Unable to replace null value in the column. Sample model attached. https://1drv.ms/u/s!AhqwbtIVEKQ2b8mGSC8la64lBLM?e=rEqmc3

CNENFRNL
5 years ago
suvechha Generally speaking, that's a empty (zero-length) string instead of null (null is concrete value in PQ, which means "no value" for any data type).
You may try this

Solution Sage

5 years ago

suvechha , update the below query in the formula bar

= Table.ReplaceValue(#"Duplicated Column","","Not Assigned",Replacer.ReplaceValue,{"Technician - Copy"})

If this works accept as solution and leave a like.

Regards,

Manikumar