About miguello

miguello

Ok, it's Overlap vs. Overlapping. And still I don't see any effect on my charts.

miguello

Somehow it isn't working in JMP 15 even when you run it from Scripting Index: What am I doing wrong?

miguello

I need to have a label offset for all my labels (if I choose to label a row) on my plots. So, I have 8 plots through "Group X". In each plot I have exactly 30 points. I'm trying to do the following: rgb = Report (gb); For( i = 1, i <= 8, i++, frame = (gb << report)[FrameBox(i)]; seg = frame << Find Seg( Marker Seg( 1 ) ); for(j = 0, j < 30, j++, seg << label offset({j, 10, -60} ) ); ); But it doesn't work. If I spell out numbers 0 through 29 in label offset it works perfectly. Like this: seg << label offset( {0, 10, -60} , {1, 10, -60} , {2, 10, -60} , {3, 10, -60} , {4, 10, -60} , {5, 10, -60} , {6, 10, -60} , {7, 10, -60} , {8, 10, -60} , {9, 10, -60} , {10, 10, -60} , {11, 10, -60} , {12, 10, -60} , {13, 10, -60} , {14, 10, -60} , {15, 10, -60} , {16, 10, -60} , {17, 10, -60} , {18, 10, -60} , {19, 10, -60} , {20, 10, -60} , {21, 10, -60} , {22, 10, -60}, {23, 10, -60}, {24, 10, -60}, {25, 10, -60}, {26, 10, -60}, {27, 10, -60}, {28, 10, -60}, {29, 10, -60} ); What am I doing wrong? How do I script setting offsets for all 30 points? I tried to play with Substitute(), Expr() and Evl() - but no luck.

miguello

Strange, in my case it still creates a new table.

miguello · ‎09-14-2020

Jim, thanks a lot.... This is the brute force solution I hoped to avoid. I don't like regular expressions because it is hard for me to understand them, but I think the way I posted below should be working just fine and is pretty simple and elegant.

miguello · ‎09-14-2020

Ok, looks like this is going to work: :numberColumn =Num( Regex(:characterColumn, "[0-9]+"));

miguello · ‎09-14-2020

One of my users complained that my add-in wasn't working. It was cutting off all the data for one of the variables below 100. Upon troubleshooting I found that it is due to the way I convert "Column NN" to just number "NN". The source CSV file doesn't have column names, so when I import it, JMP assigns default names. My user has language set to Japanese so it imports CSV files naming columns as "列NN" which breaks my formula for numbers less than 100 (I was just taking the three right symbols, so numbers less than 100 were still coming out as numbers). I can easily fix it this case, but let's say I want to make it 100% language independent, and I don't know all the local formats in which in might imports the header-less CSV file - how would I convert something like "CCCNNCCC" to "NN" - where "CCC" - arbitrary number of chars and "NN" arbitrary number of numbers? Some RegExp magic?

miguello · ‎08-13-2020

Yeah, looks like this is the easiest workaround. Thanks!

miguello · ‎08-13-2020

Is there any way to have a two-line label for a reference line? My lable has to be long and it eats up a lot of valuable screen space. Would be ideal if I could break it into two lines. Any way to achieve that?

miguello · ‎08-10-2020

All, I have the following problem I would like some help with: I have a population of parts each installed in their respective tool. There is some parameter that is measured on the part prior to the installation on the tool (:InspectionValue) and also the same parameter measured on that part while it was installed in the tool (:CurrentValue). The task is the following - I need to show that the variations between parts is intrinsic to the parts themselves, rather than comes from it being installed on a specific tool. What would be the statistically correct way of showing that based on the provided data? So far my idea is to compare two values: :InspectionValue - :CurrentValue - this is my difference between inspection and on tool results :CurrentValue - Mean(:CurrentValue) - This is how current value differs from tool to tool. But they are roughly on the same scale. Visually I can see that tools do not affect the values of the parts, and differences are intrinsic to the parts, but I'm not sure how to show that statistically. Anything ideas?

miguello · ‎07-16-2020

Jim, Yes, I came to the same conclusion. Only I'm doing a temp summary table for all byVariables and read it into an Associative Array. My data table structure and plots are much more complicated than I showed, that's why. What I'm trying to do now and what I'm struggling with is finding the right AxisBox on my plot.

miguello · ‎07-16-2020

All, I need to modify my Scripted Graph Builder so that it sets various scales for each plot. I have a table of the (simplified) form: :date - just a date :rawValue - some numeric value :byVariable - several categorical values to separate :rawValues into groups :rawMedian - just a median value for each of the groups, formula Col Quantile(:rawValue, 0.5, :byVariable) I plot it this way: Graph Builder( Size( 800, 500 ), Show Control Panel( 0 ), Show Legend( 0 ), Variables( X( :date ), Y( :rawValue ), Y( :rawMedian ) //It's just a straight horizontal line on each plot ), By( :byVariable ) ) Now, I would like to set the Y axis scale for each plot separately, and be equal, let's say, 3*:rawMedian for that specific :byVariable. What's the best way of doing this? Thanks, M.

miguello · ‎05-28-2020

Any suggestions on how to open\convert a BMP (bitmap image) file as\to a table? Ideally would like to have columns like X, Y, R, G, B with all the information, so that when plotted would resemble actual BMP. Might be some external converter first, then open a CSV file, might be a script that reads binary file and poarses into a tble, might be some built in function?

miguello · ‎04-03-2020

Ok, I got it. Provided the values are numerical, you can just calculate range between columns, doing this: Maximum(<list of all the columns>) - Minimum(<list of all the columns>) If it's not zero - there is difference in at least one column.

miguello · ‎04-03-2020

All, Any ideas how to quickly do the following task: I have N columns with values, that ideally should be identical, or some values might be missing (this is OK). I need to see if for a specific row either all the values are the same or missing, or if there is at least one column with value that is not the same?

miguello · ‎10-23-2019

Understood. Thanks a lot. Explanation in the scripting index or help is definitely not enough to understand which way the nesting goes: either it's all the scripts that are included into a script it's been called form or all the scripts that come from where it called to the root one.

miguello · ‎10-22-2019

Hello all, I'm trying to use Include File List() and I'm getting errors. It is not working as I would have expected. Here is an example. I have 3 files files named Include1.jsl, Include2.jsl, Include3.jsl that I'm trying to include into TestInclude.jsl that is listed below: Clear Log(); //Names Default To Here( 1 ); Clear Symbols(); Clear Globals(); Include( "Include1.jsl" ); Include( "Include2.jsl" ); Include( "Include3.jsl" ); show(Include File List()); All four files are in the same folder. Each of the three included files have their corresponding show("IncludeScriptN"); where N is 1, 2 and 3 When I'm running the TestInclude,jsl, I'm expecting to see: "IncludeScript1"; "IncludeScript2"; "IncludeScript3"; Include File List() = {"C:\...\TestingLocaleScipts\TestInclude.jsl", "C:\...\TestingLocaleScipts\Include1.jsl", "C:\...\TestingLocaleScipts\Include2.jsl", "C:\...\TestingLocaleScipts\Include3.jsl"}; Instead I see this: "IncludeScript1"; "IncludeScript2"; "IncludeScript3"; Include File List() = {"C:\...\TestingLocaleScipts\TestInclude.jsl"} So, included files ARE indeed included, they DO indeed work, but function does not show them? What am I doing wrong? Thanks, M.

miguello · ‎09-10-2019

Thanks! This solves the problem of pre-launch checks. However, it would still be useful to know how to close an App window. Closing it by the title as was suggested eariler does not seem to be reliable as title can change (and I do change title in my scripts for various windows). Is there any way to get a handle on the main App window? Thanks, M

miguello · ‎09-04-2019

Ok, I tried the following: Created a blank App, default Module1 name. Created one button with the following code: Button1Press=Function({this}, // This function is called when the button is pressed name = this << Get Button Name; show("Trying to close App"); thisModuleInstance << Close Window; thisApplication << Close Window; Module1 << Close Window; ); None of the three options worked. How do I get the name of the Application window then? Thanks, M.

miguello · ‎09-04-2019

All, I cannot find a way to do the following: Let's say I have an App that is in the form of AddIn. For it to successfully run it needs some conditions met. When they are not I want to create a modal window with description what's needed to run the App and on hitting "OK" button close the App (not JMP though). How can I close a running App within this App using JSL (I'm going to put it as script to Butotn Box with "OK"). Thanks, M.

miguello · ‎09-04-2019

Is Scriptable(dbc); works just fine, anybody has a code snippet with modal window that would just close the whole AddIn in case it evaluates "0"? Thanks, M.

miguello · ‎09-04-2019

Many of my scripts connect to a DB as soon as they are started. DB is in intranet, so users need to: 1. Be connected to internal network OR have VPN on 2. Have ODBC source set up correctly Sometimes they don't. I want to warn users that the DB is not available instead of script erroring on them. What would be a correct way of checking if "Create Database Connection" was successful and returned a valid handle? Thanks, M.

miguello · ‎06-26-2019

I found the problem. Somehow Page() was inside Variables(), so when I replaced it with By(), the latter ended up inside Variables() as well. It should be outside.

miguello · ‎06-26-2019

I tried that and it just plots everything on one plot and saves it on one plot as well, as if it just ignores By(). Also, I've read about this "Dialog" button - where can I find it? I don't see it on my graph builder.

miguello · ‎06-26-2019

All, Trying to save a GraphBuilder with PAGE into a PowerPoint. Idea was that each graph is saved into its own slide. It does. However, the picture object that is placed on the graph looks weird - it is a very tall white rectangle (as tall as all the plots in GraphBuilder) with one particular plot being at the top. Just like in the picture Any ways to fight it? Thanks, Mikhail

miguello · ‎06-25-2019

Awesome, thanks! Exactly what I had in mind, for some reason got stuck on constructing formula code by external means when I could easily do that in the table itself.

miguello · ‎06-25-2019

Yeah, I wouldn't call this more elegant. I've seen this solution, yes, but I'd rather stick to my current solution. Thanks a lot!

miguello · ‎06-25-2019

All, Simple task, but on a great scale. I have a table with two columns that have two different naming conventions for the same thing. Few hundreds of rows. Let's say something like that: NATO reporting name Common name Faceplate Mikoyan-Gurevich Ye-2A **bleep**ot Mikoyan-Gurevich MiG-15 Fang Lavochkin La-11 Fantail Lavochkin La-15 Fantan Nanchang Q-5/A-5 Fargo Mikoyan-Gurevich MiG-9 Farmer Shenyang J-6 and Mikoyan-Gurevich MiG-19 [1] Feather Yakovlev Yak-15/Yak-17 Fencer Sukhoi Su-24 Fiddler Tupolev Tu-28/Tu-128 Fin Lavochkin La-7 Finback Shenyang J-8 Firebar Yakovlev Yak-28P Firebird Chengdu J-10 Fire Fang Chengdu J-20 Firkin Sukhoi Su-47 Fishbed Mikoyan-Gurevich MiG-21 Fishcan Chengdu J-7[2] Fishpot Sukhoi Su-9 and Su-11 and so on. Now I need an easy way of creating a Match formula out of these columns. Any suggestion rather than parsing the table externally and adding pieces of formula around it? The reason I need a formula, and not a Virtual Join or something is that I have a column that have mixed names, some are Nato reporting name some are common names. Formula would work on Nato names, changing it to Common Names, leaving Common Names untouched. Also, any other way of reducing two naming conventions in one column to one if I have a table of matched names from both conventions? Thanks!

miguello · ‎06-21-2019

Right now I have it implemented this way: path = "c:/temp/"; pathProcessed = path||"processed/"; listOfFiles = Files In Directory(path); for(i=1, i<=N Items(listOfFiles), i++, if(Contains(listOfFiles[i], ".jmp")>0, Move File(path||listOfFiles[i], pathProcessed||listOfFiles[i])); ); but it looks awkward...

miguello · ‎06-21-2019

How do I perform File Functions on multiple files using wildcards? Let's say after finished with files I'd like to sort them into corresponding folders like that: Move Files("c:/temp/*.jmp", "c:/temp/processed_jmp/"); Move Files("c:/temp/*.csv", "c:/temp/processed_csv/"); Looks like this won't work with wildecards. I'd hate to go into getting list of all files, break it into separate lists for each extension, then making FOR loops to iterate through each file.... Is there a more elegant way of doing that?

Date Registered	‎01-27-2016 11:55 AM
Date Last Visited	4 weeks ago
Total Messages Posted	113
Total Kudos Received	15

Online Status	Offline
Date Last Visited	4 weeks ago