Transformation Steps

Once you have imported, added cleaning steps, and loaded data to your database, you can then add Transformation Steps and create Views from them. To do this, you can go to the table you want to start out with, and click on the Transform tab for that table. Note that you need to use double-quotes (" ") around your table and columns names when you use custom SQL steps.

You can add a transformation step by directly clicking on the column name of the column you want to transform in the Spreadsheet UI, or by adding a step from the sidebar by clicking on the '+' button.

For a complete list of Transformation Steps, go to the Steps section in the documentation.

Adding Transformation Steps

There are 2 ways to add Transformation Steps to your data.

From the sidebar: You can add Steps by clicking on the '+' button. Doing so will bring up a component that lets you search and choose which Step you want to apply to your data.

From the Spreadsheet UI: You can also click on any of the column headers for the columns you want to clean. You will see a dropdown with a categorized list of some of the Cleaning Steps that you can apply on that column. When you click on any of those, a Step will be added.

Either way to add a transformation step results in your data being processed the same way for the same Step. The only difference is that adding Steps from the column header automatically targets the selected column whereas adding a step from the Sidebar requires you to select which column you want to target for processing.

Removing Steps

Removing Steps can be done from the sidebar. You can simply click on the trash icon on a Step to remove it. You may have to re-run the last Step to refresh the data in the Spreadsheet UI.

Running Steps

You can Run Steps by clicking on the "Run" button on a Step. Running Steps will be applied to your imported data in a sequential manner.

Note that clicking on the "Run" button on an individual Step will run that Step along with all the Steps before it. This ensures that you get the most accurate view of your processed data up to the Step you run.

To make this point clear, if there is only one Step, then clicking "Run" will only run that one Step. If you run the last Step, it will run all steps. However, if you run a Step that's anywhere in the middle (i.e. neither the only Step nor the last Step), then Dropbase will run all Steps up to and including the Step you clicked on. Any Step after the one you ran will remain un-processed.

After a Step is ran, you can click on a Step to view a Snapshot of your data after that Step has been applied.

Snapshots: see how your data changes

After you apply any processing Step and it finishes running, the Spreadsheet UI will refresh with the new data that reflects the applied Step. Clicking on a previous or earlier Step allows you to preview how the data looked like before you applied the latest Step. These previews are called Snapshots. This is a great way to track how your data is changing as you apply processing Steps to it.