How to refer to a column with unknown name

Monomorphist

Can anybody tell me how to send a column name (that I don't know beforehand and that will be determined while running the script) to a graph report, eg:

variable1 = "Metal";

name1 = "Width of " || variable1;

Overlay Plot(

    X( : Price ),

    Y(        : (Column (name1))  ),

This works to change line color:

    : Name ("Width of Metal") (Connect Color( 19 )

But I don't know the column name, because it depends on variable1. Therefore, I need to replace the expression  Name ("Width of Metal") and use the variable name1. I've tried

: Name (name1), : Column (name1), :name1      etc etc etc etc etc. Nothing works. But surely there's a way to incorporate a variable into the column name for the SendTo Command?

Regards,
Kofi

txnelson

Here is the method I use:

Names Default To Here( 1 );

dt = Open( "$SAMPLE_DATA/big class.jmp" );

variable1 = "ght";

name1 = "Wei" || variable1;

Eval(

      Substitute(

                  Expr( Overlay Plot(

                   X( :height ),

                   Y( __var__ ),

                    Separate Axes( 1 ),

                    Connect Thru Missing( 1 ),

                    __var__( Connect Color( 19 ), Overlay Marker( 8 ) ),

                    SendToReport(

                    Dispatch(

                    {},

                                     "Overlay Plot Graph",

                    FrameBox,

                    {DispatchSeg( Line Seg( 1 ), {Line Color( "Medium Dark Red" )} )}

                    )

                 )

              )

         ),

            Expr( __var__ ), Parse( ":" || name1 )

      )

);