what tool can work same as data cleansing does
@Aakanksha_chandak you can use the formula tool or multi-field tool
@Aakanksha_chandak
Formula tool can do it for you.
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
Hi, @Aakanksha_chandak
Maybe you can show the screenshot of error as your said.
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 ?
Sample data:
At the time, you need upload the screenshot of tool set tips.
Select all the fields to cleanse, nothing to select in remove null rows and columns.
Based on the data you provided, I haven't been able to reproduce the glitch you said here, but my guess is that it could be that your source data has changed after multiple runs, so the fields will no longer be recognized or missing.
yes, which is why I want to lock data cleansing fields, so that with multiple runs, it doesnt get affected because my output suffers because of data cleansing.
So, you still need use Multi-Field Formula tool to get your want best.
