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
Enable Transform Data with the enableUserTransformations setting.
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.
The feature can edit values and remove rows. It cannot add 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.
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.
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.