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

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