NULL Values

I am working on a flow that "Cleanses" data so it can load into our system properly. Some columns have data in some rows but other rows are empty. The Output results with "NULL" in these empty cells and I need these cells to remain empty.

I used the 'Replace Nulls - Replace with Blanks (String Fields)' and the columns that are completely empty remain empty, my issue is with the columns with a mismatch of empty and populated data.

Is there a way I can return nothing within these empty cells?

Thanks,

Regina

Developer Tools

Accepted answers

AbhilashR

@reginawhelan - @T_Willins's solution should have worked. Would it be possible for you to share a screenshot of your data that you are looking to adjust?

Attached is an example of a couple of ways I usually address this ask.

sample.yxmd

All comments

T_Willins

Hi @reginawhelan,

You can add a Formula tool (or a Multi-Field Formula tool if you have multiple fields to change) with the following formula: IF IsNull([fieldname] THEN "" ELSE [fieldname] ENDIF

reginawhelan

Hi there, not sure if you received my reply earlier but even when using this formula the value is "NULL" and I need the value to be nothing. Do you know what I could be doing wrong?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703