Data cleansing tool substitute

[Aakanksha_chandak]

what tool can work same as data cleansing does

[binuacs]

@Aakanksha_chandak you can use the formula tool or multi-field tool

[ShankerV]

@Aakanksha_chandak 

Formula tool can do it for you.

[Aakanksha_chandak]

How to replace blanks, remove nulls, zero, whitespaces with multifield formula?

[Christina_H]

The Data Cleansing tool is a macro, you can open it up to see how it works.

E.g. to replace nulls with 0, scroll across to the right to find correct container.  It looks like the formula used is either in the macro questions or in the action tool connected to the macro.

Replace with 0 (macro questions)

Replace all whitespace (action tool)

[Aakanksha_chandak]

actually I have numerous data cleansing tools in my workflow and when i run it multiple times, several field names get unchecked because of which "numeric strings" get unpopulated etc, how to sort this issue

[flying008]

Hi, @Aakanksha_chandak 

Maybe you can show the screenshot of error as your said.

[Aakanksha_chandak]

There is no error, its just data cleansing tool automatically un-checks some of the fields resulting in numeric field output to become zero

[flying008]

Can you upload sample data to test ?

[Aakanksha_chandak]

Sample data: