How to manage column with no values

[lumjingbki]

I have 2 columns one is int and the other is string data type. please find attached. I want to assign a value to these when it is null or empty. can someone help how to achieve this

[alexnajm]

What value do you want to assign? Do you have an expected output?

[lumjingbki]

@alexnajm if [Date] is blank then 20240101 else [Date]  if [status] is blank then "Status is blank" else [status]

[lumjingbki]

@alexnajm if [Date] is blank then 20240101 else [Date]  if [status] is blank then "Status is blank" else [status]

[cjaneczko]

All you need is a formula tool after that.

Date

if isnull([Date]) then tonumber(datetimeformat(DateTimeparse('20240101','%Y%m%d'),'%Y%m%d')) else [Date] endif

Status

if IsNull([Status]) then 'Status is blank' else [Status] endif

 

[lumjingbki]

@cjaneczko am not getting the required results even after using the given formulas. Are you providing having any blank rows in the input tool. 

[cjaneczko]

Yes, the text input data matches your screen cap with date as Int 64 and Status as VString. Can you provide sample data?

[cjaneczko]

Find attached the sample workflow. Also a screen cap of the input and output.