cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to move from signal modeling to system modeling at the first JMP Aerospace Analytics webinar. Register. June 18, 1 p.m. US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
Crish42
Level I

Import data from csv file when given the lower and upper bounds

I have csv files exported from Instron (data.csv), and I'd like to import the data from one column given the lower and upper bounds specified for another column. I have an image below that demonstrates what I'm interested in. I have values in B1 and B2 that specify the lower and upper bounds of the data from column A (between A12 and A33). I want to write a script in JMP that extracts the corresponding data from row C (between C12 and C33) that matches the values in column A. Any help would be appreciated. Thank you!

Instron data.png

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Import data from csv file when given the lower and upper bounds

Do two exports, one for the limits (this could be just as text if you want to or table as it is easier to use) and one for the date. Then get the limits, create a comparison to select the rows based on the limits, invert selection and delete the rows you aren't interested in. And finally remove the columns you don't need.

-Jarmo

View solution in original post

1 REPLY 1
jthi
Super User

Re: Import data from csv file when given the lower and upper bounds

Do two exports, one for the limits (this could be just as text if you want to or table as it is easier to use) and one for the date. Then get the limits, create a comparison to select the rows based on the limits, invert selection and delete the rows you aren't interested in. And finally remove the columns you don't need.

-Jarmo

Recommended Articles