> ## 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.

# How to Combine Likes & Dislikes for Joint Analysis

> Easily merge multiple columns (e.g., likes & dislikes) using Smart Columns, no extra tools needed.

Want to analyze *likes and dislikes* together in one go without any manual copying or external tools? With **Smart Columns** in Caplena, you can now merge multiple open-ended responses, like positive and negative feedback, and analyze them together in just a few clicks.

Here’s how to do it step by step:

<Danger>
  When merging **Likes** and **Dislikes** into a single column, please note the following to avoid unnecessary credit consumption:

  * **Likes and Dislikes must be imported as *Text* columns**, not as TTA (Text-to-Analyze).
  * If Likes and Dislikes are uploaded as separate TTA columns and then merged, the system will count **three TTA columns in total** (Likes + Dislikes + Merged), and credits will be charged accordingly.
</Danger>

<iframe src="https://www.loom.com/embed/d9450fd0ea0949ea8634c4f10668537f" 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 />

## Step 1: Create a New Smart Column

<Steps>
  <Step>
    Go to your **Data** page.
  </Step>

  <Step>
    Click on **"Create New Smart Column."**
  </Step>

  <Step>
    Give your new column a name, for example:\
    `All Feedback Combined` or `Likes & Dislikes`.
  </Step>

  <Step>
    Under **Column Type**, choose:\
    `Text-to-analyze` – this will ensure the column is available for AI topic analysis.

    <Frame>
      <img src="https://mintcdn.com/caplena-32172960/By5v1z9FUTqZ31Dr/images/Screenshot-2026-05-22-at-17.03.51.png?fit=max&auto=format&n=By5v1z9FUTqZ31Dr&q=85&s=1f00a645eebe44261789e09825302e42" alt="Screenshot 2026 05 22 At 17 03 51" width="1570" height="1502" data-path="images/Screenshot-2026-05-22-at-17.03.51.png" />
    </Frame>
  </Step>
</Steps>

## Step 2: Choose the Smart Column Mode

<Steps>
  <Step>
    Select the **Formula** mode.\
    This allows you to merge the content from multiple columns.
  </Step>

  <Step>
    Use the **"Likes & Dislikes" template** — it's specifically designed for this type of task and will automatically generate a helpful formula.

    <Frame>
      <img src="https://mintcdn.com/caplena-32172960/By5v1z9FUTqZ31Dr/images/Screenshot-2026-05-22-at-17.06.34.png?fit=max&auto=format&n=By5v1z9FUTqZ31Dr&q=85&s=9ffd0de63bef7befe093623de850b467" alt="Screenshot 2026 05 22 At 17 06 34" width="1394" height="774" data-path="images/Screenshot-2026-05-22-at-17.06.34.png" />
    </Frame>
  </Step>
</Steps>

## Step 3: Select Columns to Merge

* Choose the two columns you want to combine, e.g.:
  * `What did you like?`
  * `What didn’t you like?`
* Optionally, add labels like:
  * `"Positive: "` and `"Negative: "`\
    This helps you (and the AI) better understand the source of each text.

<Frame>
  ## Step 4: Preview & Create
</Frame>

<Steps>
  <Step>
    Click **"Generate Sample"** to preview the result.
  </Step>

  <Step>
    If everything looks good, click **"Create & Fill"**.
  </Step>

  <Step>
    Done! 🎉\
    Your new column will now be populated and ready to use
  </Step>
</Steps>

<Frame>
  <img src="https://mintcdn.com/caplena-32172960/By5v1z9FUTqZ31Dr/images/Screenshot-2026-05-23-at-14.51.32.png?fit=max&auto=format&n=By5v1z9FUTqZ31Dr&q=85&s=09e99f246621c5f758390324d6d0d36e" alt="Screenshot 2026 05 23 At 14 51 32" width="3256" height="1016" data-path="images/Screenshot-2026-05-23-at-14.51.32.png" />
</Frame>