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?
Solved! Go to 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.
Thx @DataNath forgot about that tool. I don't use it that often :)
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |