Data can be transformed for many different reasons. Here are a few examples:

• Correcting data errors
• Unifying the data before doing aggregations (e.g. Sum)
• Ability to join data from different tables

Data can be transformed in Peliqan in three different ways:

1. Using Formulas in the Peliqan Spreadsheet Editor
2. Using SQL queries in the Peliqan Query Editor
3. Using Low-code Python code in the Peliqan Data App editor

Transforming data in Peliqan

1. Using formulas

Add a new column to a table using column type “Formula”. Write a formula to transform data from other columns.

2. Using SQL queries

Add a new table of type “SQL query”, and write your own SQL query to create a new table. You can use any SQL statement to transform the data.

You can also define your own Database functions (Custom functions) which can be used in your SQL queries.

3. Using low-code Python

See Building Data Apps for more information. You can for example process the rows of a table in a Python script, and write the result to the same table (in other columns), or write to a separate table, or write to a report file (PDF, Google Sheet etc.).

Various Data Transformation scenarios

Here are examples of common data transformations for various use cases:

Convert numeric status fields to readable text