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

• Changing a date format
• Converting from one currency to another
• Unifying the data before doing aggregations (e.g. Sum)
• Ability to join data from different tables
• Etc.

Data can be transformed in Peliqan in different ways:

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

Transforming data in Peliqan

Using SQL queries

Add a new table of type “SQL query”, and write an SQL query that transforms the data.

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 output table.

Various Data Transformation scenarios

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

Convert numeric status fields to readable text

Merge data from multiple similar sources (e.g. SaaS)