> ## 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 Add Additional Columns for Analysis After Upload

> Missed a TTA column during import? Here's how to bring it in later—no reupload of the full dataset needed.

Did you forget to include a column for analysis during your data upload? No worries — there are two ways to bring that column into your analysis using **Smart Columns** or **Add & Replace**.

## Option 1: Using Add & Replace

If Smart Columns are not available or preferred, you can re-import the column using the **Replace** flow.

<Tip>
  The original dataset must contain a **unique identifier** column (for example, UUID or user ID).
</Tip>

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

<Steps>
  <Step title="Prepare your file">
    Include the **unique identifier** column (e.g., UUID, respondent ID) and the **column(s)** you forgot to include originally.
  </Step>

  <Step title="Replace Data">
    In your project, go to **Data → Replace Data** and upload your new file.
  </Step>

  <Step title="Match and add columns">
    Select the **identifier column** to match existing rows, then select the **new column(s)** to be added.
  </Step>

  <Step title="Configure and complete">
    **Check the TTA box** if the column should be treated as open text, select the option to **add as a new column**, and complete the upload.
  </Step>
</Steps>

## Option 2: Using a Smart Column (if included in your plan)

If you have **Smart Columns** enabled, you can turn an existing column into a **Text to Analyze (TTA)** column.

<Steps>
  <Step title="Open Smart Columns">
    Go to your project and open the **Smart Columns** panel, then click **Create Smart Column**.
  </Step>

  <Step title="Select column type">
    Select the column type **"Text to Analyze"**.

    <Frame>
      <img src="https://mintcdn.com/caplena-32172960/j8tdvVd7cDdtTO_3/images/Screenshot-2026-05-23-at-14.58.34.png?fit=max&auto=format&n=j8tdvVd7cDdtTO_3&q=85&s=e18cf93a7e6d51786b683a1b5bc2e669" alt="Screenshot 2026 05 23 At 14 58 34" width="2536" height="1638" data-path="images/Screenshot-2026-05-23-at-14.58.34.png" />
    </Frame>
  </Step>

  <Step title="Choose Formula and Variable">
    Choose **Formula**, click on **Variable**, and select the column you'd like to turn into a TTA field.

    <Frame>
      <img src="https://mintcdn.com/caplena-32172960/j8tdvVd7cDdtTO_3/images/Screenshot-2026-05-23-at-14.59.29.png?fit=max&auto=format&n=j8tdvVd7cDdtTO_3&q=85&s=a5439402307839bc1438a2e439c9cbaf" alt="Screenshot 2026 05 23 At 14 59 29" width="2588" height="1066" data-path="images/Screenshot-2026-05-23-at-14.59.29.png" />
    </Frame>
  </Step>

  <Step title="Create & Fill">
    Click **Create & Fill**.

    <Frame>
      <img src="https://mintcdn.com/caplena-32172960/j8tdvVd7cDdtTO_3/images/Screenshot-2026-05-23-at-15.00.12.png?fit=max&auto=format&n=j8tdvVd7cDdtTO_3&q=85&s=82d62b5aca713a677ac1bac62a3223c7" alt="Screenshot 2026 05 23 At 15 00 12" width="2596" height="870" data-path="images/Screenshot-2026-05-23-at-15.00.12.png" />
    </Frame>
  </Step>
</Steps>

<Tip>
  Your selected column will now behave like any other open-ended field and can be included in your analysis.
</Tip>
