45163_en-US

liliconcom

Comparing datasets from two different files

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?

Re: Comparing datasets from two different files

Thank you for the update

Re: Comparing datasets from two different files

I've updated the link in the post above. 

Re: Comparing datasets from two different files

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?

Re: Comparing datasets from two different files

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

Re: Comparing datasets from two different files

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.