Skip to main content

AI editing with user transformations

Dromo's Transform Data feature allows your users to create bulk transformations from natural language and execute them on the dataset. The feature is available on the Professional and Enterprise plans.

Overview​

tip

Enable Transform Data with the reviewStep.enableUserTransformations setting.

With enableUserTransformations enabled, you will see a "Transform data" button on the Data Review step.

Transform data button

Click this button to open the Transform Data modal. You will be prompted for what you would like to do to your data.

Transform data prompt

Transform Data takes a user's request and turns it in to a transformation that can be applied to the data. If the request was successfully able to produce a transformation, the result is previewed to the user so they can optionally accept or reject it.

Data Change Preview

The feature can edit values and remove rows. It cannot add rows.

Remove low value rows

Best Practices​

Include context about inputs​

The AI building the transformation function never has access to the import data, so including context about both the input and output is often helpful.

For example, given a column containing dates formatted like "Jul-8-1999" where you wish to convert them to "07/08/1999," you should request "Change the date format from 'Jul-8-1999' to MM-DD-YYYY." A request unlikely to succeed would be "Change the dates to US format" because the AI does not have access to the current format.

date-example

Only apply transformations to one row at a time​

A transformation only has access to an individual row. If you need to perform an operation that requires knowledge of other rows or information outside of the table, the transformation will not succeed.

failed prompt

Keep Expectations Realistic​

Transform data performs best when it is given a simple, well-scoped task. Changing values based on simple criteria, adjusting date and time formats, and removing rows based on simple conditions are all great uses for the transform data feature.

Privacy​

Dromo sends the request to OpenAI along with some information about the schema, but absolutely no user data is transmitted as part of this process.