Formulas

This guide will walk you through the process of adding a new column to an Aleph table using a formula. This method allows you to transform existing data or combine data from different columns without the need for complex coding.

Introduction

In Aleph, you can enhance your data tables by adding new columns that manipulate or combine existing data. There are several ways to create a new column:

• 📄 Mappings: Define a direct relationship between existing data and new values.

• Formulas: Use simple formulas to transform data from one or multiple columns into a new column.

This guide focuses on the formula method to create a new column that categorizes departments into functions.

Create a New Column Using a Formula

1. Go to https://app.getaleph.com/tables and select the table where you want to apply the formula

2. Click "Add column" in the top right

3. Select the "Formula" option

4. Define the new column, by filling out the Column Name and the Formula sections

5. Click on "Save & Preview"

Tips and Best Practices

• Error Handling: If you encounter errors during the "Save & Preview" step, carefully read the error messages to troubleshoot your formula.

• Comprehensive Mapping: Ensure that your CASE statement covers all possible values or includes an ELSE clause to handle unexpected data.

• Testing: Before relying on the new column for critical analysis, test it to ensure that it accurately reflects the intended transformations.

• Documentation: Add comments or descriptions within your formula if supported, to explain complex logic for future reference.