✨Clean

Data often arrives in a less-than-ideal state. AuditBoard Analytics's suite of cleaning tools can help you automate data cleanup. Simple tools like Find & Replace or Text to Columns can help prep data before transformation. Check incoming data for specified conditions by using the Validate tool.

Find Replace

Find text strings in a dataset, replace with new text

Text to Columns

Split one column into many based on characters in that column

Sample

Pull just a portion of data from a tool, based on selected rules

Validate

Confirm your data meets expectations, includes lookup checks

Parse JSON

ParseJSON offers the ability to flatten or explode JSON objects from one JSON column into new broken out columns in your dataset. You can also select the max level to flatten if you want to flatten to deeper levels in the JSON string.