Overview of YouPrep™
What is YouPrep™?
YouPrep™ is Toucan's no-code data preparation module. Our visual interface enables non-technical business users to transform their data thanks to operations available within a few clicks.
YouPrep™ will help you with most of the data transformations you need (filtering, computation, aggregation, text and date operations, reshaping, and combining several datasets)
YouPrep™ interface
YouPrep™ interface breaks down into 2 panels:
The transformation pipeline on the left shows the ordered series of transformation steps applied to your data. When you need to configure a given step, the left panel switches to the step edition form
the data table preview on the right is where you can click on your data to apply transformations.
The right panel also includes widgets above the table. Transformations are available from the columns headers and widgets or can be found via the search bar.

You have different ways to use YouPrep™:
By using the transformation on the column header:

By using the widgets:

Or through the search bar:

The resulting step appears in the transformation pipeline whenever you interact with the table or widgets to transform data. Any step can be edited, moved, or deleted. If a step in the middle of the pipeline gets edited or deleted, the following steps remain unchanged.
If you click on any step of the pipeline, the data table on the right will update to show you the result of the transformations until this step. Following steps get greyed to show that they are temporarily disabled and not executed. In that sense, the pipeline acts as a history you can navigate. It can be very helpful when debugging!
Native SQL - Data transformation delegation
The is a feature named NativeSQL within the product that allows to translate the YouPrep data transformation pipeline into an SQL statement when the preparation has been made on top of SQL connectors.
Last updated
Was this helpful?