- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Comparing datasets from two different files
I tryed different things, but the joining by matching variables was the best way for me.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Comparing datasets from two different files
I've updated the link in the post above.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Comparing datasets from two different files
Thank you for the update