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