cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
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