Example of importing/exporting data prep steps
To easily apply the data prep steps to clean your data in future data sets, export the
steps. Then, import the steps to new data connections.
Specify data prep steps
From your data preview, decide what data steps are necessary to clean the data. For more information, go to data prep steps.
In this example, we collect data about insurance claims for car incidents. Because we
have similar data across many files, we want to save our data prep steps to apply to
new data sets. We created 8 data steps:
- Initial cleanup to trim whitespace and format dates appropriately.
- Remove invalid rows where the age of the driver is greater than 100 years old.
- Change M to male.
- Change F to female.
- Change marital status from numeric to text data type.
- Change 0 to no.
- Change 1 to yes.
- Merge gender and marital status into a single column.
Export data prep steps
To save the steps, export them as a .mdcs file. The export file contains only the
data prep steps that you create, not the initial cleanup step.
- Select Export Steps from the dropdown menu.
- The file is saved to your downloads folder or other save location and uses
the same name as your data file. Change the name accordingly.
Import data prep steps
To apply the steps to a new data file, import them as a .mdcs file. Select Import Steps from the dropdown menu. 
