Dynamic Data Cleansing - without cleansing one column

Question

Hi,

I'm trying to cleanse data after it goes through the crosstab tool. I have a formula to find a month over month delta and when the value is null, the delta doesn't calculate properly, so I use a data cleansing tool after the crosstab. My issue is that my column names change every month (dates) so I always have to update the data cleansing tool.  I know that I can fix this through using the multifield tool (in the screenshot below) but I'm wondering if there's any way I can tell alteryx to not cleanse one of my columns. Like is there a formula I can make to cleanse all my date columns but not change anything in my first column (customer name)? Can I add something to this formula as an exclusion?

flying008 · Answer

Hi, @maygross

Maybe you can upload sample data of input and want output to explain your need.

apathetichell · Answer

likewise - datacleanse has the ability to select only certain fields to "cleanse."

binu_acs · Answer

@maygross Multi-Field formula tool has the option to select fields based on the data type. If your date fields are in DateTime data type then select that option, One thing you cannot assign a blank value to the DateTime field data type, it will throw a conversion error and assign NULL values. One option is to change the data type of your date fields into String and then assign the blank value if any of the values is NULL

Multi-Field_141123.yxmd