...
In the Preview Data pane, scroll to the right. Verify that the location
field was deleted and all null values in the two address fields were replaced with n/a
. Note that AutoPrep only replaces literal nulls and missing key/value pairs, not empty strings:
...
...
Mask Data
The example data contains customer IDs that you might not want to expose to all who will use the prepared data. Follow these steps to mask the data:
In the field header, hover over the right side and click the three dots to open the options menu:
Select Mask.
Select the MD5 algorithm and note how AutoPrep changes the values in the id column.
Click Done to save the transformations.
...
Change the Date Format
The location_last_seen
column contains a Date String in MM/dd/yyyy. To be more precise about the time, choose the MM/dd/yyyy option that includes hours and minutes:
Click the AutoPrep Snap to reopen it.
In the location_last_seen field header, hover over the right side, click the three dots to open the options menu, and select Format:
Select MM/dd/yyyy HH:mm:
Click Apply.
AutoPrep changes the format:
...
View the Results
If Pipeline validation is not disabled for the Org and Auto Validate is enabled in user settings, you can preview how AutoPrep will prepare the data set at runtime. To finish this exercise:
...