nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Help with Script for select specific rows

lmoraga

Hi all; I hope ypu are doing great...

I'm wonderig if somebody can helpme with this:

I have a Data Table wich minitoring VAV (Variable air volume box) temperature every 5 minutes, and Table contains data from two weeks of monitoring (from sunday to saturday, from 12:00am to 11:55pm every day).

I need to develop a Script for select and create a new table but only whit data collected on bussines days, I mean, only the data what was collected from Monday to Friday, from 8:00am to 6:00pm.

Really thaks for any help!

VAV monitoring.JPG

Accepted answers

All comments

MikeD_Anderson

Try using the JMP Table Query Builder (Under the table menu of JMP). You can set up filters and generate a new table. It writes the code for you and saves the query as a separate file if you want to rerun later.

lmoraga

Thanks for the help.

I was trying and reading about, but I couldn't enable the Query Builder function. Can you tell me how to enable it?

MikeD_Anderson

What version of JMP are you running?

lmoraga

JMP Pro 11.1.1