topic Importing answers based on multiple column values in Discussions

Importing answers based on multiple column values

OmegaGnu430 — Sat, 10 Jun 2023 23:52:59 GMT

Hi JMP community,

I have a list of responses which I need to import into JMP. I have an Excel sheet containing the responses along with 3 columns containing information I need to import the data by. Picture below:

I need to import the responses into the corresponding JMP file based on the response ID, Survey and Choice set.

However I can't seem to find a good answer/starting point on how to import and sort data based on shared column values. Could someone please give me pointer on how to start?

Best regards

Re: Importing answers based on multiple column values

Ressel — Thu, 11 Aug 2022 11:46:42 GMT

Maybe the following will help.

You have two tables, one in Excel and one in JMP. Make a JMP version of your Excel table. Then, via the toolbar go to Tables --> Join. There you can match your columns in the "Matching Specification" panel. At least for me, table joining (and splitting) operations are typically error prone before I get them right, so I strongly advise to tick "Keep dialog open" when testing whether this method can work for you.