Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Use the AutoPrep Snap to prepare data for analysis, reporting, and machine learning without writing expressions. When you open AutoPrep, it uses introspection on a sample of the input data and calculates the probable data type and valid null handling for each field. The Preview data table shows a sample of the data it will output.

...

  • Flatten leaf nodes of hierarchical data structures

  • Remove fields

  • Rename fields

  • Change the data type of String, Date, Integer, Number, and Boolean fields

  • Handle null values

  • Mask data to protect sensitive data

  • Beta - Choose the format for dates, currency, phone numbers, and country codes

  • Beta - Split fields based on a delimiter to create new fields

The following screenshot shows the AutoPrep point-and-click interface:

...