Empty values

[Lean_Sawko]

Hi all,

Just wanted the most common way to change a COLUMN B to blank/empty because this one has other values not required if COLUMN A is Blank. 

If Column A is blank then I want the column B blank as well.  Do you use formula or another tool?

Thanks, 

[Luke_C · Accepted solution]

Hi @Lean_Sawko 

You could use a formula tool and empty quotes '' to make a column empty. You could also use null() if you wanted it to be null instead. see below - B uses the null method and C uses the empty quotes. 

[Lean_Sawko]

Hi, @Luke_C  Thanks for your help, as I can see this case doesn't apply to my WF because COLUMN A its not completely empty. in the cases where it is, I want COLUMN B empty as well. 

It makes sense to you?

[Luke_C · Accepted solution]

@Lean_Sawko Totally, so you could do something like this in the formula tool for column B. The formula would check if column A is empty and make column B empty as well, otherwise it would leave column B untouched.

IIF(isempty([COLUMN A]),'',[COLUMN B])

edit - added missing parenthesis