filmov
tv
Data Cleansing Tool in Alteryx workflow
Показать описание
Data Cleansing tool helps to remove all unwanted characters like spaces, punctuation, letters and white spaces.
Select Fields to Cleanse: Select the fields to cleanse using the configuration options below. All options, except for Replace Nulls with 0, apply to string data types. To specify different options for different fields, use multiple Data Cleansing tools in your workflow.
Replace Nulls: To replace nulls with values other than blanks or 0, use the Imputation Tool.
Replace with Blanks (String Fields): A Blank registers as "" rather than [Null]. Selected by default
Replace with 0 (Numeric Fields): Selected by default.
Select Fields to Cleanse: Select the fields to cleanse using the configuration options below. All options, except for Replace Nulls with 0, apply to string data types. To specify different options for different fields, use multiple Data Cleansing tools in your workflow.
Replace Nulls: To replace nulls with values other than blanks or 0, use the Imputation Tool.
Replace with Blanks (String Fields): A Blank registers as "" rather than [Null]. Selected by default
Replace with 0 (Numeric Fields): Selected by default.