About uday_guntupalli

uday_guntupalli · ‎08-20-2019

uday_guntupalli · ‎08-14-2019

@almighty22 , Can you please provide a copy of your log ? If you wouldn't mind a small subset of your data table as well. I don't see a reason for it to fail especially if there is data in that range.

uday_guntupalli · ‎08-14-2019

@almighty22, There are many ways to get to what you want. The following is just one: 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(""); 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.

uday_guntupalli · ‎08-14-2019

@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

uday_guntupalli · ‎07-22-2019

Thanks to @gblatz , the following works: Eval( Parse( Eval Insert( " Platform Preferences( PathVar( MATLABROOT32( \!"^matlab_32bit_path^ \!" ), MATLABROOT( \!"^matlab_64bit_path^\!" ) ) );" ) ) );

uday_guntupalli · ‎07-22-2019

All, I am trying to set platform preferences dynamically based on User Input collected using a UI. Essentially, the user specifies which Matlab version is installed on their machine and I am using that to construct a 32-bit and a 64-bit path to the root variable for Matlab on the users machine. However, this repeatedly results in an error: Unexpected "\MATLAB\R2018a\". Perhaps there is a missing "," or ")". Trying to parse arguments of function "MATLABROOT32". Any help or advice is appreciated. user_matlab_ver = '2018a' ; // for example matlab_32bit_path = "C:\Program Files (x86)\MATLAB\R2018a\"; matlab_64bit_path = "C:\Program Files\MATLAB\R2018a\"; Eval( Parse( Eval Insert("\[ Platform Preferences( PathVar( MATLABROOT32( ^matlab_32bit_path^ ), MATLABROOT( ^matlab_64bit_path^ ) ) );]\" ) ) ); ConnectToMatlab = Expr( matlab_conn = MATLAB Connect(); matlab_conn_flag = matlab_conn << Is Connected; ); ConnectToMatlab;

uday_guntupalli · ‎07-22-2019

Essentially what worked is uninstalling Matlab and getting it re-installed. This was the advice I got from Technical Support and that seemed to do the trick.

uday_guntupalli · ‎06-21-2019

All, I was able to get JMP to work with Matlab 2018b , but had to downgrade to 2018a for a specific project. What I have done thus far: 1. Created an environment variable called MATLABROOT - "C:\Program Files\MATLAB\R2018a\" 2. Checked if the PATH system variable has the Matlab Path - ""C:\Program Files\MATLAB\R2018a\bin\" (this is where the matlab executable is installed) When I try to run a simple test, it fails to establish a connection with Matlab: Can anybody help ?

uday_guntupalli · ‎05-22-2019

@nascif_jmp and @bryan_boone , Thank you for your responses. Your responses helped me get somewhere, however I have a couple of questions: 1. Can you kindly provide an example of accepted JSON array format in JSL ? Is this accepted ? 2. Does the scripting index or scripting guide cover the portions on JSON array or how to define an empty JSON object as nasicf has kindly shown ? a. If yes, I would like to read that b. If no, I would request that this be added to the documentation, because I couldn't find it anywhere

uday_guntupalli · ‎05-17-2019

@markbailey , When I use "[ ]" , that results in an error.

uday_guntupalli · ‎05-17-2019

@vince_faller, So the issue is stemming from this: If the associative array has a key with no value, then upon using the As JSON Expr(), it gets translated to this wierd operator(?) which is not something that can be parsed properly which in turn throws an error. In my case, I just dropped the key from my Associative Array and it worked, however I am curious to know what is the right way to pass such a parameter ?

uday_guntupalli · ‎05-16-2019

@vince_faller , As some of the parameters are not something I can share here, I sent it to you as a private message. You will see from the message that the hard-coded example and the As JSON Expr() have the same parameters , the values are dynamic, but it results in an error as I have shown earlier.

uday_guntupalli · ‎05-15-2019

All, I am wondering how to build a dynamic JSON object in JSL ? request = New HTTP Request( url( "http://httpbin.org/post" ), Method( "POST" ), JSON( "\[{"username":"bob","address":"12345"}]\" ) ); Using the example from the scripting index, if I wantedt to vary the username from bob to say mark and address from 12345 to 12346 and I have 10 such calls, I would prefer building that as a dynamic object outside. I initially ventured down the path of building it as an Associative Array and then using the As JSON Expr() , however, that is resulting in an error. My approach in that case was: MyAA = Associative Array(); MyAA["username"] = "bob" ; MyAA["address"] = "12345" ; request = New HTTP Request( url( "http://httpbin.org/post" ), Method( "POST" ), JSON( As Json Expr(MyAA)) ); Of course, this is not happening for this example, but the api I am trying to call on. However, when I pass hardcoded JSON as an input, the api call works as expected. Any help is appreciated.

uday_guntupalli · ‎05-13-2019

A number edit box can be easily formatted as a date by using the following numbox = Number Edit Box( 0 ,<< set format(format("ddMonyyyy")), << set(Today())); NW1 = New Window( "Example", numbox ); However, in order to achieve a similar result with a number col edit box, the formatting requires the user to pass a number as an argument to the format function. This is not intuitive and the user is left to guess what might or might not work. I would like to request the number col edit box also be provided the functionality to accept commonly known formatting types as a number edit box. Here is an example // Using Number Col Edit Box nR = 7; NEB1 = Number Col Edit Box("StartDate",Repeat(Today() - 30 * 24 * 60 * 60,nR)); NEB1 << set format(format("ddMonyyyy")); NEB2 = Number Col Edit Box("StartDate",Repeat(Today(), nR )); NEB2 << set format(format("ddMonyyyy")); TB1 = Table Box(NEB1,NEB2); NW = New Window("test",TB1); See Format a Number Col Edit Box for discussion.

uday_guntupalli · ‎05-13-2019

@markbailey, Thank you . While that works, it is not intuitive that a number will implement some kind of formatting on the number col edit box, rather than the more intuitive format that the number edit box allows. I will be adding this to the wish list.

uday_guntupalli · ‎05-13-2019

All, I would like to use a number col edit box similar to a number edit box in that, I would like to format it to display a date. However, as shown in the following example the format doesn't seem to be accepted the same way ? Can someone point out whats wrong in the following approach ? // Using Number Col Edit Box nR = 7; NEB1 = Number Col Edit Box("StartDate",Repeat(Today() - 30 * 24 * 60 * 60,nR)); NEB1 << set format(format("ddMonyyyy")); NEB2 = Number Col Edit Box("StartDate",Repeat(Today(), nR )); NEB2 << set format(format("ddMonyyyy")); TB1 = Table Box(NEB1,NEB2); NW = New Window("test",TB1); // Using number edit box numbox = Number Edit Box( 0 ,<< set format(format("ddMonyyyy")), << set(Today())); NW1 = New Window( "Example", numbox );

uday_guntupalli · ‎05-02-2019

@Morten , You can easily do that in JMP. If you wanted to do that using a script, here is an example: dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); gb1 = dt << Graph Builder(Variables( X( :sex ), X( :age, Position( 1 ) ), Y( :height ) ), Elements( Points( X( 1 ), X( 2 ), Y, Legend( 24 ) ) ) ); If you wanted to use the interactive platform, just drop a variable on the x-axis . Then bring the second variable and hover it on the x-axis, JMP will tell you what will happen depending on where you drop it .

uday_guntupalli · ‎05-02-2019

@Jenn1 , Maybe try something like this. dt = Open( "$SAMPLE_DATA/Big Class.jmp"); Avg_Age = Mean(dt:Age << Get Values); If(Avg_Age > 13.5, Mail( "YourEmail", "Test Passed", "The average age in big class dataset is > 13.5", "$SAMPLE_DATA/Big Class.jmp" ); ); Note that, with this approach, a pop up window will come up asking you to "allow" or "deny" the file to be e-mailed.

uday_guntupalli · ‎04-05-2019

All, This is my over-zealous super excited JMPER looking around the internet for any tidbits or previews on JMP 15. I don't seem to find much infomration, can anybody post the roll out date for JMP 15 and throw some spoilers on cool features ? @Jeff_Perkinson or @Craige_Hales or @markbailey

uday_guntupalli · ‎04-04-2019

@bordini , I know you say you dont have SAS, but did you know you could download SAS University edition for free ? If you really need to test SAS code, you could download SAS university edition and try it. https://www.sas.com/en_us/software/university-edition/download-software.html I dont know how to perform the equivalent step in JMP, so I will be watching for other answers too 🙂

uday_guntupalli · ‎04-03-2019

@Stokes , Maybe something like this ? I am assuming that you want the script to always use the current date because you did not specify what that value needs to take. START_DATE = "03Apr2019_19_19_34"; CurrTime = As Date(Today()); CurrTimeChar = Char(CurrTime); Left = Words(CurrTimeChar,":"); Date = Left[1]; DesDate = Date || "_" || Char(Hour(CurrTime)) || "_" || Char(Minute(CurrTime)) || "_"|| Char(Second(CurrTime)); START_DATE = DesDate;

uday_guntupalli · ‎04-02-2019

@adnan019 , There are multiple ways to do this. I will show you a few: // Create Data Set 1 dt = New Table("Character Data"); dt << New Column("CharacterSet",Character,Nominal,<< Set Values({"A","B","C"})); // Create Data Set 2 dt1 = New Table("Numerical Data"); dt1 << New Column("NumericalSet",Character,Nominal,<< Set Values({"1","2","3"})); // Approach -1 dt2 = dt1 << Concatenate( dt); dt2 << New Column("ConcatenatedData",Character,Nominal,Formula(If(IsMissing(:CharacterSet),:NumericalSet,:CharacterSet))); // Approach - 2 ValsFromTable1 = dt:CharacterSet << Get Values; ValsFromTable2 = dt1:NumericalSet << Get Values; AllData = ValsFromTable1 || ValsFromTable2; dt3 = New Table (); dt3 << New Column("ConcatenatedSet",Character,Nominal,<<Set Values(AllData)); Note that I modeled the numerical data as character, this is to enable the concatenation

uday_guntupalli · ‎03-29-2019

@lwx228 , Try this ? dt = Open("$SAMPLE_DATA/Big Class.jmp"); // Clear Row Selection dt << Select Randomly(0.1); dt << Clear Select(); // Clear Column Selection dt << Select columns({:age,:sex}); dt << Clear Column Selection();

uday_guntupalli · ‎03-27-2019

@NDENNIS418 , It is much more easier to do this using matrices. Here is a way to do what you want: // I am using a sample data set for illustrative purposes only dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); // Extract Numeric Data as a matrix Mat = dt << Get As Matrix; // Define your condition Condition = (Mat == 12 | Mat == 60 | Mat == 85); // edited the values to show some sample results // Now you can subset the values easily like so Mat1 = Mat[Loc(Condition)];

uday_guntupalli · ‎03-23-2019

@MikeD_Anderson , Can these features be extended to Script Editor as well ?

uday_guntupalli · ‎03-23-2019

This is a great suggestion. This is a prominent feature available in Matlab. (https://www.mathworks.com/help/matlab/matlab_prog/run-sections-of-programs.html) .

uday_guntupalli · ‎03-23-2019

@guillaumebugnon , You could use either C# or Visual Basic to save csv files as .jmp files. You can find demos or examples under your installation path which might look like this (SAS\JMP\14\Samples\Automation)

uday_guntupalli · ‎03-23-2019

The current documentation of Python Get() states that : It would be helpful to add the ability to also retrieve dictionaries from Python. Dictionaries are commonly used in Python and will easily translate into Associative Arrays in JMP.

uday_guntupalli · ‎03-22-2019

@abdulj , You could use matrices to identify conditions that you want to test against. Here is an example, Clear Log(); // Open a sample data set dt = Open( "$SAMPLE_DATA/Cars.jmp" ); // Extracting numeric column names ColNames = dt << Get Column Names("String"); NumericCols = []; for(nCol = 1, nCol <= N Items(ColNames), nCol++, DType = Column(dt,nCol) << Get Data Type; If(DType == "Numeric", NumericCols = NumericCols || nCol; ); ); NumericColNames = ColNames[NumericCols]; // Extract numeric data only Mat = dt << Get As Matrix; // Row Wise Test // For e.g. Find all rows where year < 90 YearCondition = Loc(Mat[0,1] < 90); Show(Mat[YearCondition,0]);

uday_guntupalli · ‎03-21-2019

Actually, I missed the part where you wanted to get a cumulative sum, rather just the sum. I am pretty sure there is smarter and more efficient ways to do this. This will work though. I am essentially creating the raw data as well, for you to test and play with // define values Col1Vals = {"a","a","a","a","b","b","c","c","c"}; dt = New Table(); dt << New Column("MyValues",Character,Nominal,<< Set Values(Col1Vals)); // Generate summary dt1 = dt << Summary( Group( :MyValues ), Freq( "None" ), Weight( "None" ) ); UniqueItems = dt1:MyValues << Get values; FrequencyOfItems = dt1 << Get As Matrix; Close(dt1,"No Save"); // Add Cumulative Frequencies back dt << New Column("CumulativeFreqCount",Numeric,Continuous); for(i = 1, i <= N Items(UniqueItems),i++, Rows = dt << Select Where(:MyValues == UniqueItems[i]) << Get Selected Rows; ValsToAppend = Transpose(Index(1,FrequencyOfItems[i])); dt[Rows,"CumulativeFreqCount"] = ValsToAppend; dt << Clear Select; );

Date Registered	‎09-15-2014 01:08 PM
Date Last Visited	‎08-01-2020 01:11 PM
Total Messages Posted	591
Total Kudos Received	296

Online Status	Offline
Date Last Visited	‎08-01-2020 01:11 PM