Unable to replace null values in one column ?

Hi there, Unable to replace null value in the column.

Sample model attached.

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

CNENFRNL
Community Champion
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
manikumar34
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
Icey
Community Support
5 years ago
Hi suvechha ,

Please let us know if the replies above are helpful.

If they are, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please give us more details.

Best Regards,

Icey

Forum Discussion