Subscribe Bookmark RSS Feed

Comparing datasets from two different files

PF

New Contributor

Joined:

Sep 27, 2017

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?

1 ACCEPTED SOLUTION

Accepted Solutions
ian_jmp

Staff

Joined:

Jun 23, 2011

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.

2 REPLIES
ian_jmp

Staff

Joined:

Jun 23, 2011

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.

PF

New Contributor

Joined:

Sep 27, 2017

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