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

# Creating a Helper Column (e.g. Wave or Year)

> Add simple wave or year labels to keep your datasets organized and comparable.

When you upload several datasets, or example, monthly or yearly data, it’s helpful to **differentiate between uploads** by assigning a label such as *Wave 1*, *Wave 2*, or *2024 / 2025*.

This allows you to:

* Filter or segment results per upload
* Compare time periods (e.g., “Wave 1 vs Wave 2”)
* Create clear visualizations over time

Caplena offers an easy way to do this using Smart Columns.

You can easily create a new **Formula Column** that assigns the same value to all records in your dataset. This is the easiest and most efficient method. When you upload new data waves, you can include this column directly in your dataset to clearly highlight which records belong to each wave or year.

**How to do it:**

<Steps>
  <Step>
    Go to **Columns → Add Column → Smart Columns → Formula**
  </Step>

  <Step>
    Choose **Output type:** Text
  </Step>

  <Step>
    Enter the following formula: `Wave 1   ` or `2025   `
  </Step>

  <Step>
    Save the column
  </Step>
</Steps>

This will add a new column with the same value (“Wave 1” or “2025”) for every row in your dataset.

<iframe src="https://www.loom.com/embed/874078a855cc44c1a18272821212a75b" title="Loom video player" frameborder="0" className="w-full aspect-video rounded-xl" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen />