Hi all. I've looked around to see if there is a script that adds/imports a csv file while still keeping the old data.   My objective is to have a master JMP file. Then everytime I test a different device/different date, I would like it to be added to the master JMP Data table without overwriting it. I've seen code that meshes all csv files in a folder, but I would like it for just one csv file at a time. (All files have the same columns)     ... View more

dt = Open( "\\someFile.jmp", invisible); path = "\\path\to\folder\"; names = { "Amplitude 1/2 Vppse", "Amplitude Vppde"}; ngraphs = N Items( names ); For( ip = 1, ip <= ngraphs, ip++, current_graph = dt << Variability Chart( invisible, Y( Column(dt, names[ip])), X( :Temp, :vccl), Std Dev Chart( 0 ), SendToReport( Dispatch( {"Variability Chart for " || names[ip]}, "2", ScaleBox, {Label Row( {Show Major Grid( 1 ), Show Minor Grid( 1 )} )} ), Dispatch( {"Variability Chart for " || names[ip]}, "Variability Chart", FrameBox, {Row Legend( Serial, Color( 1 ), Color Theme( "JMP Default" ), Marker( 1 ), Marker Theme( "Standard" ), Continuous Scale( 0 ), Reverse Scale( 0 ), Excluded Rows( 0 ) )} ) ) ); current_graph rep = current_graph << Report; chart_type = Char(current_graph << Title); chart_type = Munger(chart_type, 1, "[]", ""); If(chart_type == "Variability Chart", name = current_graph rep[TextEditBox(1)] << Get Text ); name = Munger(name,1,"/", "_"); final_name = chart_type || "_" || name ; picture_path = path || Char(final_name) || ".png"; current_graph << Save Picture( picture_path, "png" ); )   Help! So I have managed to make a for loop to make a graph for each column that I put in my array. This actually works 🙂   BUT, it looks like the legend does not show up even though I have it in the script. I also notice that in a blank jmp file that just has data and no scripts that run, my data points are just black dots instead of the colored markers I have specified in my script. Is this connected? Do I have to run a script in the data set, and then run the whole .jsl script like the one above after? Why isn't my legend showing up the way I have it specified in my script. ... View more

is there a way to use variables to substitute names in JMP? When I try the code below, it doesn't run. I will be making a for loop where I make a graph and change the Y axis so I'm really hoping there is a way this can work, rather than copying and pasting for every graph I'd want to output.   names = {"Hair Color", "Eye color", "Age", "Gender", "Age 1/2"}; graph = dt << Variability Chart(             Y( :Name(names[1])),             X( :City),            Std Dev Chart( 0 ) );   ... View more

graph1 = dt << Variability Chart( Y( :Name( "Age in 2019" ) ), X( :Gender ), invisible, Show Range Bars( 0 ), Show Cell Means( 0 ), Std Dev Chart( 0 ), Automatic Recalc( 1 ), ); This is a bit from my .jsl script where I have multiple graphs. Is there a way to easily query the Name of whatever graph is in my queque? For Example... in any object oriented language it would look something like this: graph2.Y.Name. This would get the name of the Y axis. I need the name in order to save the graph with the proper name based on the Y axis. ... View more

I would like to save the graph area without the local filter, not the gray area to my powerpoint. So far, it saves 4 slides for 2 graphs. One slide has the local filter, and the other has the actual graph area. I would only like it to export the graph area since it's a high resolution.   This is the code I have so far: graph1 is a variability graph, graph3 is a distribution graph. Also if possible, is it possible to save both graphs in one picture? obj = New Window("TJ mUI " || Long Date(Today()), V List Box( "vlb1", Panel Box( "Figure 1", graph1 ), Page Break Box(), Panel Box( "Figure 2", graph3 ))); obj << Set page setup(margins (1,1,1,1), scale(1), portrait(1), paper size("Letter")); path = "Z:\SAF\JMP_Data\"; obj <<save picture(path || "testPNG.png", png); obj << save presentation("Z:\SAF\JMP_Data\jmp_powerpoint_example.pptx"); ... View more

I have a data set where I have conditions, and different measurements taken.    For example: Sex       Age       Height       Shoe size Male      20          66 in.         10 Female  18          60 in.          8   I am making a script to view distribution, and variation. I would like to make graphs for height, and shoe size(seperately). In some instances  I have some height outliers (let's assume), but the shoe size is still valid. What line of code would I have to add to my scripts, to not include the outlier rows in one of my scripts... but include it in my other script? If I use hide/exclude, it disappears completely and doesn't show up in any graphs. I would like to have control to which graphs show which rows. I am using the Variability Gauge Chart and Distribution Charts. ... View more