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:
...
The following screenshot shows the AutoPrep point-and-click interface:As you apply transformations, the Preview data pane refreshes. The Review summary tab saves a history of each transformation and provides a way to remove individual transformations. Your changes are not saved until you click Done and exit AutoPrep. After your transformations are saved, if structural changes occur to input data, AutoPrep will warn you about those changes the next time you open it.
...