topic Re: Comparing datasets from two different files in Discussions

Comparing datasets from two different files

PF — Wed, 27 Sep 2017 07:47:36 GMT

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

ian_jmp — Tue, 01 May 2018 17:38:34 GMT

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.

Re: Comparing datasets from two different files

PF — Wed, 27 Sep 2017 09:28:57 GMT

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

Re: Comparing datasets from two different files

triunk — Tue, 01 May 2018 17:09:04 GMT

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

Jeff_Perkinson — Tue, 01 May 2018 17:39:37 GMT

I've updated the link in the post above.

Re: Comparing datasets from two different files

triunk — Mon, 21 May 2018 18:01:06 GMT

Thank you for the update