NULL Values

[reginawhelan]

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

[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? 

[AbhilashR · Accepted solution]

@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.

[reginawhelan]

Yes, thank you very much for your help