Use the Data Transformation Feature in Boost.space Database

Note: This article is only for Boost.space 4.0 users.

Note: To access this feature, you’ll need AI Credits.

Overview

The AI Data Transformation function in Boost.space allows users to enhance and refine data within a specific column using advanced AI-powered transformations. This tool enables flexible data manipulation, from cleaning and translating to extending and customizing content based on user-defined prompts.

Video

How It Works

This feature can be applied to a selected column within your Boost.space database to automatically process and improve its contents. You can choose from pre-configured transformation template or create your own custom transformations prompt.

Key Features:

Templates for Common Transformations:
- Data Cleaning: Cleanse and standardize data in a selected column, removing extra spaces, correcting typos, and formatting dates and numbers for consistency
- Data Transform (Standardize): Convert and standardize data.
- Shorten: Make content shorter and to the point.
- Extend: Add more details to give fuller picture.
- Fix spelling & grammar: Corrects linguistic mistakes in texts to enhance clarity and correctness.
- Translate: Translate the text from one language to another.
- Data Enrichment: Make data better by adding more useful information.
- Data Extraction: Pulls specific pieces of information from a larger dataset or document, like names, dates, or prices.
- Censor and anonymize: Censors personal information.
Custom Prompts: For specialized needs, users can write their own prompts, such as “Make all letters capital” or “Format as title case.” This flexibility allows you to tailor transformations exactly to your requirements.

How to Use the AI Data Transformation Feature

Select a Column:
- Start by choosing the column that you wish to transform.
Choose a Transformation:
- Select from one of the pre-made templates or enter a custom prompt for a more tailored transformation.
Preview the Transformation:
- Use the Preview feature to see how the transformation will affect your data before finalizing it. This helps you verify the outcome and make any adjustments if needed.
Adjust Advanced Settings:
- Automatic Execution: Choose between Manual or Auto execution to control when transformations should be applied.
- Tone of Voice: Adjusts the style of the text output, making it suitable for formal, casual, or other tonal needs.
- Creativity: Sets the level of creativity for the AI. A lower setting will be more precise, while a higher setting may yield more diverse responses.
Execute the Transformation:
- Once satisfied with the settings, you can run the transformation. You can either Save the configuration or Save & Run to immediately apply it.