column names in lists

arnow

Hello,

I'm quite unfamiliar with JMP scripting and have the following problem: In a production environment, there are several process steps and for each process step there several tools. At the end measurements are performed and i need to create tool-trends for theses measurements where the measurements is on the y-axis, the date is on the x-axis and the data are group by the tool used for the lots. In order not to repeat essentially the same code several times i try the follwing for a particular measurement:

First, i create a tool-list und a date list:

tool_list=list("Tool1", "Tool2", "Tool3");

date_list=list("Date1", "Date2", "Date3");

Next, i use for to loop through the lists:

for(i=1, i<= nitems(tool_list), i++, ...)

Now, the items in each list are column names in the data table and i need to assign these to the graph builder platform. I tried something like this:

Variables(X(date_list(i)), Y(measurement1), Group Y(tool_list(i))

However, JMP does not recognize, that date_list(i) is a column name. Is there a way to specify that?

Thanks for any help!

Regards

Arno

pmroz

You need to use square brackets instead of parentheses for referencing list elements.  Here's an example:

dt = open("$sample_data\Car Physical Data.jmp");

xlist = {"Gas Tank Size", "Weight"};

ylist = {"Displacement", "Horsepower"};

glist = {"Type", "Country"};

for (i = 1, i <= nitems(xlist), i++,

    print(i);

   

    Graph Builder(

        Show Control Panel( 0 ),

        Variables( X( column(dt, xlist[i]) ),

                Y( column(dt, ylist[i]) ),

                Color( column(dt, glist[i]) ) ),

        Elements( Points( X, Y, Color, Legend( 2 ) ) ),

        SendToReport( Dispatch( {}, "Graph Builder", FrameBox, {Marker Size( 3 )} ) )

    );

);