Did you forget to include a column for analysis during your data upload? No worries, there are two easy ways to bring that column into your analysis using Smart Columns or the Add & Replace.
Option 1: Using the Add & Replace
If Smart Columns are not available or preferred, you can re-import the column using the Replace Flow:
💡The original dataset must contain a unique identifier column (e.g., UUID or user ID).
Steps:
-
Prepare a new file that includes:
-
The unique identifier column (e.g., UUID, respondent ID).
-
The column(s) you forgot to include originally.
-
-
In your project, go to Data → Replace Data.
-
Upload your new file.
-
Select the identifier column to match existing rows.
-
Select the new column(s) to be added.
-
Check the TTA box if the column should be treated as open text.
-
Select the option to add as a new column.
-
Complete the upload.
Option 2: Using a Smart Column (If included in your plan)
If you have Smart Columns enabled, you can convert an existing column into a "Text to Analyze" (TTA) column:
Steps:
-
Go to your project and open the Smart Columns panel.
-
Click Create Smart Column.
-
Select the column type "Text to Analyze".
-
Choose Formula.
- Click on Variable and choose the column (variable) you'd like to turn into a TTA field.
- Click Create & Fill.
💡 Your selected column will now behave like any other open-ended field and can be included in your analysis!
