cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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

Recommended Articles