Comparing datasets from two different files

[#1]

Hi Everyone

I need a little help to get past this.

I have two datasets in two different files. I need to compare multiple columns in the two files and then get the data which is exactly the same in a new file. I thought about loops but I don't know if JMP scripts can do that?

[#2 · Accepted solution]

I think you are asking for a JSL script, and 'yes' you can use loops. It's usually good practice to let JMP generate code for you and then build on that. With that in mind, I would try playing with Compare Data Tables interactively with some of your data and see where that leads you. Be aware there are many ways one could approach this problem.

[#3]

I tryed different things, but the joining by matching variables was the best way for me. 

[#4]

Hi Ian,

I am afraid the link of the phrase "compare data tables" does not work

Might you be able to redirect us to the right link?

[#5]

I've updated the link in the post above. 

[#6]

Thank you for the update