https://community.jmp.com/t5/Discussions/How-to-link-header-with-survey-questions/m-p/570163#M78053 <P>Cols menu has recode column names</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_1-1668626510240.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/47394i878E20ECC299FFBE/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_1-1668626510240.png" alt="jthi_1-1668626510240.png" /></span></P> <P>&nbsp;</P> <P>And from Advanced you can find mapping</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1668626497684.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/47393iFE256E291B50AFC0/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1668626497684.png" alt="jthi_0-1668626497684.png" /></span></P> <P>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</P> Wed, 16 Nov 2022 19:23:54 GMT jthi 2022-11-16T19:23:54Z https://community.jmp.com/t5/Discussions/How-to-link-header-with-survey-questions/m-p/570130#M78050 <P>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.</P> Sat, 10 Jun 2023 23:57:05 GMT https://community.jmp.com/t5/Discussions/How-to-link-header-with-survey-questions/m-p/570130#M78050 RankMonster1074 2023-06-10T23:57:05Z https://community.jmp.com/t5/Discussions/How-to-link-header-with-survey-questions/m-p/570163#M78053 <P>Cols menu has recode column names</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_1-1668626510240.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/47394i878E20ECC299FFBE/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_1-1668626510240.png" alt="jthi_1-1668626510240.png" /></span></P> <P>&nbsp;</P> <P>And from Advanced you can find mapping</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1668626497684.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/47393iFE256E291B50AFC0/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1668626497684.png" alt="jthi_0-1668626497684.png" /></span></P> <P>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</P> Wed, 16 Nov 2022 19:23:54 GMT https://community.jmp.com/t5/Discussions/How-to-link-header-with-survey-questions/m-p/570163#M78053 jthi 2022-11-16T19:23:54Z