> ## Documentation Index
> Fetch the complete documentation index at: https://help.peliqan.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Data transformations

> Transform data in Peliqan using SQL queries or low-code Python to change formats, convert currencies, unify data, and prepare tables for joins and aggregations.

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](/data-apps.md) 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:

[Status values to readable text](/status-values-to-readable-text.md)

[Currency conversions](/currency-conversions.md)

[Merge similar sources](/merge-similar-sources.md)

[Mapping charts of accounts](/map-charts-of-accounts.md)

## Overview of available transformations in Peliqan

**ROW TRANSFORMATIONS**

<table>
  <colgroup>
    <col width="212" />

    <col width="325" />
  </colgroup>

  <thead>
    <tr>
      <th>Transformation</th>
      <th>Description</th>
    </tr>
  </thead>

  <tbody>
    <tr>
      <td>Filters</td>
      <td>Apply filters to include/exclude rows based on various criteria in the Grid view interface</td>
    </tr>

    <tr>
      <td>Advanced filters</td>
      <td>Write SQL queries to filter your data</td>
    </tr>

    <tr>
      <td>Remove duplicates</td>
      <td>Using a Python script</td>
    </tr>

    <tr>
      <td>Edit rows</td>
      <td>Edit data in a spreadsheet-like Grid view interface</td>
    </tr>
  </tbody>
</table>

<table>
  <colgroup>
    <col width="215" />

    <col width="325" />
  </colgroup>

  <thead>
    <tr>
      <th>Transformation</th>
      <th>Description</th>
    </tr>
  </thead>

  <tbody>
    <tr>
      <td>Filters</td>
      <td>Apply filters to include/exclude rows based on various criteria in the Grid view interface</td>
    </tr>

    <tr>
      <td>Advanced filters</td>
      <td>Write SQL queries to filter your data</td>
    </tr>

    <tr>
      <td>Remove duplicates</td>
      <td>Using a Python script</td>
    </tr>

    <tr>
      <td>Edit rows</td>
      <td>Edit data in a spreadsheet-like Grid view interface</td>
    </tr>
  </tbody>
</table>

**COLUMN TRANSFORMATIONS**

<table>
  <colgroup>
    <col width="218" />

    <col width="325" />
  </colgroup>

  <thead>
    <tr>
      <th>Transformation</th>
      <th>Description</th>
    </tr>
  </thead>

  <tbody>
    <tr>
      <td>Arithmetic</td>
      <td>Apply calculations & aggregations in SQL</td>
    </tr>

    <tr>
      <td>Case / if</td>
      <td>Apply "if" logic in SQL</td>
    </tr>

    <tr>
      <td>Comparison</td>
      <td>Compare numbers, dates, text in SQL</td>
    </tr>

    <tr>
      <td>Text manipulation</td>
      <td>Apply text manipulations in SQL</td>
    </tr>

    <tr>
      <td>Date manipulation</td>
      <td>Apply date manipulations in SQL</td>
    </tr>

    <tr>
      <td>SQL queries</td>
      <td>Write SQL queries to apply any type of column transformation.</td>
    </tr>

    <tr>
      <td>Obfuscate data</td>
      <td>Obfuscate data, e.g. for GDPR reasons, using a Python script</td>
    </tr>
  </tbody>
</table>

<table>
  <colgroup>
    <col width="220" />

    <col width="325" />
  </colgroup>

  <thead>
    <tr>
      <th>Transformation</th>
      <th>Description</th>
    </tr>
  </thead>

  <tbody>
    <tr>
      <td>Arithmetic</td>
      <td>Apply calculations & aggregations in SQL</td>
    </tr>

    <tr>
      <td>Case / if</td>
      <td>Apply "if" logic in SQL</td>
    </tr>

    <tr>
      <td>Comparison</td>
      <td>Compare numbers, dates, text in SQL</td>
    </tr>

    <tr>
      <td>Text manipulation</td>
      <td>Apply text manipulations in SQL</td>
    </tr>

    <tr>
      <td>Date manipulation</td>
      <td>Apply date manipulations in SQL</td>
    </tr>

    <tr>
      <td>SQL queries</td>
      <td>Write SQL queries to apply any type of column transformation.</td>
    </tr>

    <tr>
      <td>Obfuscate data</td>
      <td>Obfuscate data, e.g. for GDPR reasons, using a Python script</td>
    </tr>
  </tbody>
</table>

**TABLE TRANSFORMATIONS**

<table>
  <colgroup>
    <col width="221" />

    <col width="325" />
  </colgroup>

  <thead>
    <tr>
      <th>Transformation</th>
      <th>Description</th>
    </tr>
  </thead>

  <tbody>
    <tr>
      <td>Join</td>
      <td>Join tables</td>
    </tr>

    <tr>
      <td>Aggregations</td>
      <td>Aggregate data using sum, avg, mean etc.</td>
    </tr>

    <tr>
      <td>Union</td>
      <td>Union two or more tables into a new table.</td>
    </tr>

    <tr>
      <td>SQL</td>
      <td>Write SQL queries to apply any type of table transformation, using JOIN, UNION, GROUP BY statements etc.</td>
    </tr>

    <tr>
      <td>Low-code Python</td>
      <td>Use low-code Python scripts to process data and to create new tables and to perform writeback (Reverse ETL) to SaaS applications.</td>
    </tr>
  </tbody>
</table>

<table>
  <colgroup>
    <col width="223" />

    <col width="325" />
  </colgroup>

  <thead>
    <tr>
      <th>Transformation</th>
      <th>Description</th>
    </tr>
  </thead>

  <tbody>
    <tr>
      <td>Join</td>
      <td>Join tables</td>
    </tr>

    <tr>
      <td>Aggregations</td>
      <td>Aggregate data using sum, avg, mean etc.</td>
    </tr>

    <tr>
      <td>Union</td>
      <td>Union two or more tables into a new table.</td>
    </tr>

    <tr>
      <td>SQL</td>
      <td>Write SQL queries to apply any type of table transformation, using JOIN, UNION, GROUP BY statements etc.</td>
    </tr>

    <tr>
      <td>Low-code Python</td>
      <td>Use low-code Python scripts to process data and to create new tables and to perform writeback (Reverse ETL) to SaaS applications.</td>
    </tr>
  </tbody>
</table>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.