Process Capability of a Column Group

rm-a

I'm trying to write a table script to run a process capability analysis on a group of columns.  I have a column group called "Specced Columns".  I've tried various permutations of the following:

dt = Current Data Table();

foo = dt << get column group( "Specced Columns");

Process Capability(

    Process Variables(

        eval(foo)

    ),

   

    ,

    Within Sigma Summary Report( 1 ),

    Goal Plot( 0 )

);

I've tried converting the names to a string, list, etc.  No matter what I try, I get the following error:

Specified Column not found in data table. in access or evaluation of 'List' , {/*###*/foo}

Process Capability cannot be launched because none of the processes can be found in the data table.

Any help is much appreciated!

txnelson

I tried several methods in an attempt to get your code to run, and did not come up with a clean answer.  However, the following code does work, even though it isn't a very clean answer.

 

Names Default To Here( 1 );

dt = Current Data Table(); 

foo = dt << get column group( "Specced Columns" );

   

// Build the required statement as a literal string 

TheStmt = "dt << Process Capability( Process Variables(" || Char( foo[1] ); 

For( i = 2, i <= N Items( foo ), i++,

       TheStmt = TheStmt || "," || Char( foo[i] ) 

); 

TheStmt = TheStmt || "), Within Sigma Summary Report( 1 ), Goal Plot( 1 ));";

 

// Run the created literal string

Eval( Parse( TheStmt ) );