Grid Central Preview

Astera Dataprep features a preview-centric grid, an Excel-like, dynamic, and interactive grid that updates in real time. This interface, with its familiar rows and columns layout, allows for easy navigation and data manipulation, mimicking the traditional spreadsheet format. It displays transformed data immediately after each operation, providing you with an instant preview. This allows you to see the impact of their transformations right away, enabling quick verification and ensuring that changes are applied correctly.

You can directly apply transformations to columns by right clicking the column header and selecting the required transformation.

If multiple columns are selected when right clicking, different transformations are available for application. For example, Concatenate Columns.

You can rename columns by double clicking the column headers.

To change a column’s data type, you can select the data type icon next to the column name and select a different data type from the drop-down menu.

You can also change column order by dragging and dropping columns to a different place in the table. Small black markers help guide you when moving columns.

In case there are any errors or warnings in the dataset, they are displayed on the Grid for easier identification. For example, here we’ve created a validation rule for Null values in the Region column:

Once the validation rule has been applied successfully, it will show the errors in the preview grid like so: