what tool can work same as data cleansing does
@Aakanksha_chandak you can use the formula tool or multi-field tool
How to replace blanks, remove nulls, zero, whitespaces with multifield formula?
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)
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
There is no error, its just data cleansing tool automatically un-checks some of the fields resulting in numeric field output to become zero
Can you upload sample data to test ?