cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar

How to link header with survey questions

I have a table t1 with survey questions. The columns are called 1a, 1b, 2a, 2b, etc. (rows are the respondents' answers). I have another table t2 with the actual questions matching the column names of t1. How can I link the column names of t1 with the actual questions in t2? For instance, assume I do a PCA, I would like to be able to read/reference the actual questions instead of 1a, 2b, etc when looking at loadings. I am currently on version 16.

1 REPLY 1
jthi
Super User

Re: How to link header with survey questions

Cols menu has recode column names

jthi_1-1668626510240.png

 

And from Advanced you can find mapping

jthi_0-1668626497684.png

This should let you recode the columns 1a, 1b... to the questions. Other option could be to stack the data and then join the questions / use virtual join

-Jarmo