Centerprise AIUnclaimed profile

Video tutorials

Community tutorials

• ▶
  Data Cleanse Transformation Tutorial in Astera CenterpriseAstera Software · 265 views · 8:15 · September 2021

What you need

Access

Free trial

Runs on

Desktop app

You’ll need

• A data source (e.g. database table) to cleanse

Skill level

Some setup — keys, settings, or a connected account

Highlights

• Data Cleanse transformation objectDrag-and-drop object in the data flow designer that maps source fields and applies cleansing rules to raw data.
• Strip whitespace, tabs, line breaksRemove all whitespace, tabs, line breaks, or specified characters from source field values.
• Replace null valuesAuto-replace nulls with blank (strings) or zero (numeric fields) during the cleanse pass.
• Find-and-replace with regex supportNormal, extended, or regular-expression search modes to replace values, e.g. changing status text or swapping delimiters.
• Case conversion and bulk expressionsConvert field text to upper/lower/title case, or apply a built-in expression (e.g. regex replace) across all mapped fields at once.