Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

empty to null on multiple columns at once?

MartWClimber
9 - Comet

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?

3 REPLIES 3
DataNath
17 - Castor
17 - Castor

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

 

DataNath_0-1661847253547.png

flying008
15 - Aurora

Hi, @MartWClimber 

 

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

MartWClimber
9 - Comet

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

Labels
Top Solution Authors