Import and export transformation steps

Use the Export and Import commands to reuse transformation steps across multiple queries. Exporting a query creates a .bck file that contains its transformation steps. Then import the file into another query.

Reusing transformation steps helps maintain consistency across similar datasets and reduces the time required to recreate the same data preparation workflow.

Find the Import and Export commands on the Transform tab.

Export transformation steps#

The following example shows how to export transformation steps from a query.

1. Open the query that contains the transformation steps that you want to reuse.
2. Verify that the Performed Steps pane lists the required transformation steps.
3. On the Transform tab, select Export.
4. Save the generated .bck file to your computer.

The exported .bck file contains all transformation steps from the selected query.

Import transformation steps#

The following example shows how to import transformation steps into another query.

1. Open the target query.

2. On the Transform tab, select Import.

3. In the Import Steps dialog, browse to or drag and drop the exported .bck file.
   

   

4. After the file uploads successfully, select Upload.

   

5. After the import completes, the imported transformation steps appear in the Performed Steps pane of the target query.

   

Continue transforming the query, or write the transformed data to a destination.