BookmarkSubscribeSubscribe to 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.

5 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. 

triunk

Community Trekker

Joined:

Nov 20, 2012

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?

Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

I've updated the link in the post above. 

-Jeff
triunk

Community Trekker

Joined:

Nov 20, 2012

Thank you for the update