Skip to main content

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.

Sometimes your open-ended feedback ends up spread across several different text columns, for example Likes, Dislikes, Improvements, or Additional comments.
If you want a clearer, stronger picture of what your customers are saying, it often makes sense to bring these fields together and analyze them as one. With Smart Columns in Caplena, you can merge any text fields in just a few clicks and run a single, unified AI analysis. No Excel formulas, no manual work, just clean, streamlined insights.
Tip to Save Credits:To merge efficiently:
  • Import the original columns as Text
  • Create one Smart Column as Text-to-analyze (TTA)
If the originals are imported as TTA, each one counts toward credit usage.The best setup is:Text → merge → one TTA Smart Column.

​
Step 1: Create a New Smart Column

1
Go to your Data page.
2
Click on “Create New Smart Column.”
3
Give your new column a name, for example:
All Feedback Combined or Unified Feedback.
4
Under Column Type, choose:
Text-to-analyze – this will ensure the column is available for AI topic analysis.
Screenshot 2026 05 23 At 15 13 06

​
Step 2: Select Formula Mode

1
Choose Formula as the Smart Column mode.
2
You can use the Merge Columns template as a starting point, it’s flexible and can be adapted for any fields you want to merge.

​
\

Step 3: Pick the Columns You Want to Combine Choose any text fields you want to analyze together, such as: This is especially useful when your survey includes multiple comment fields that touch on the same topic (e.g., satisfaction, experience, feature requests), and you want to understand the full picture without jumping between columns.
Screenshot 2026 05 23 At 15 15 12

​
Step 4: Preview & Create

1
Click Generate Sample to check if the merged text looks right.
2
If everything looks good, click Create & Fill.
Screenshot 2026 05 23 At 15 19 05
Caplena will instantly populate your new combined column for all rows.
Last modified on May 23, 2026