How to use select where to pick up particular range of value?</CODE></PRE><P> </P><P> </P></LINGO-BODY><LINGO-SUB id="lingo-sub-222397" slang="en-US" mode="NONE">Re: How to use select where to pick up particular range of value?</LINGO-SUB><LINGO-BODY id="lingo-body-222397" slang="en-US" mode="NONE"><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 488px;"><SPAN class="lia-inline-image-display-wrapper" image-alt="image.png" style="width: 488px;"><span class="lia-inline-image-display-wrapper" image-alt="image.png" style="width: 488px;"><img src="https://us.v-cdn.net/6038925/uploads/images/18919i7095B9F912A1FEFA/image.png" role="button" title="image.png" alt="image.png" /></span></SPAN></SPAN></P></LINGO-BODY><LINGO-SUB id="lingo-sub-221760" slang="en-US" mode="NONE">Re: How to use select where to pick up particular range of value?</LINGO-SUB><LINGO-BODY id="lingo-body-221760" slang="en-US" mode="NONE">What do you means the log? data table? debug results? or the script?</LINGO-BODY><LINGO-SUB id="lingo-sub-221688" slang="en-US" mode="NONE">Re: How to use select where to pick up particular range of value?</LINGO-SUB><LINGO-BODY id="lingo-body-221688" slang="en-US" mode="NONE"><P><A href="https://community.jmp.com/t5/user/viewprofilepage/user-id/15594" target="_blank">@almighty22</A> , <BR /> Can you please provide a copy of your log ? If you wouldn't mind a small subset of your data table as well. </P><P> I don't see a reason for it to fail especially if there is data in that range. </P></LINGO-BODY><LINGO-SUB id="lingo-sub-221687" slang="en-US" mode="NONE">Re: How to use select where to pick up particular range of value?</LINGO-SUB><LINGO-BODY id="lingo-body-221687" slang="en-US" mode="NONE">I changed it, but it doesn't work also. The particular range of the frequency for the S11 and S21 didn't not pop out any table :(</img></LINGO-BODY><LINGO-SUB id="lingo-sub-221686" slang="en-US" mode="NONE">Re: How to use select where to pick up particular range of value?</LINGO-SUB><LINGO-BODY id="lingo-body-221686" slang="en-US" mode="NONE">I think your issue is the col name has those parentheses in it. That is why uday_guntupalli used Name("Freq(Hz)" ) to talk about that column.</LINGO-BODY><LINGO-SUB id="lingo-sub-221673" slang="en-US" mode="NONE">Re: How to use select where to pick up particular range of value?</LINGO-SUB><LINGO-BODY id="lingo-body-221673" slang="en-US" mode="NONE"><P> </P><P> </P><P> </P><P> </P><P>What if I wanna use the way like this? But when I debug it the issues showing.</P></LINGO-BODY><LINGO-SUB id="lingo-sub-221669" slang="en-US" mode="NONE">Re: How to use select where to pick up particular range of value?</LINGO-SUB><LINGO-BODY id="lingo-body-221669" slang="en-US" mode="NONE"><P><A href="https://community.jmp.com/t5/user/viewprofilepage/user-id/15594" target="_blank">@almighty22</A>,<BR /> There are many ways to get to what you want. The following is just one: </P><P> </P><PRE><CODE class=" language-jsl">dt = Current Data Table(); // Get reference to the current data table
dt << Select Where(:Name("Freq(Hz)") >= 10 * 10^6 & :Name("Freq(Hz)") <= 100 * 10^6);
Wait(0);
// Approach 1
dt1 = dt << Subset(""); <BR />Current Data Table(dt1);
max_s11 = Col Max(dt1:Name("S11(DB)"));
min_s11 = Col Min(dt1:Name("S11(DB)"));
max_s21 = Col Max(dt1:Name("S21(DB)"));
min_s21 = Col Max(dt1:Name("S21(DB)"));
// Check
Show(max_s11);
Show(min_s11);
Show(max_s21);
Show(min_s21);For this to work, you will need to have the data table shown in the screenshot open. If you already have a reference to that datatable, you can just replace that reference in place of dt.
?
?
Re: How to use select where to pick up particular range of value?@almighty22 ,
When you say you can't access it , what do you mean ? Do you mean you can't see the table or do you mean the table is not performing the action you expect it to perform ?
It is also possible that you could be opening the tables as invisible or private. So, here is my advice:
1. Run the code step by step
2. Identify where the issue is
3. In your response, provide screenshots of what is happening and what you expect to happen
Alternatively provide random subset of your data or test what you are having problem with using Sample data
