empty to null on multiple columns at once?

[MartWClimber]

I'm trying to reduce the amount of columns in a yxdb file. First of all I want to see how many null and empty values.

for null values it is no problem but the empty (blank) values it kind of is.

so I was thinking, I need to convert all of the empty values to null via the formula tool (if is empty ....)

but for 200+ columns within the yxdb there should be an other solution to this?

[DataNath · Accepted solution]

@MartWClimber if you want to apply an expression to many fields at once, you can do so with the Multi-Field Formula. You can select certain types of fields to apply the expression to (string, numeric, date etc - or all types) and there's also an 'All' button so you also don't even need to tick them all individually.

[flying008]

Hi, @MartWClimber 

The Multi-Field Formula or Data Cleansing tool can help you do it at once.

[MartWClimber]

Thx @DataNath forgot about that tool. I don't use it that often :)