- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Stacking Columns in Script
I have a couple of questions about stacking data columns in a script. When I do it manually, I get the following script from JMP:
Data Table( "Untitled 11" ) << Stack(
columns(
:Name( "EFL 20508-17DT_CG_100ms" ),
:Name( "FFL 20508-17DT_CG_100ms" ),
:Name( "EFL 20508-18DT_CG_100ms" ),
:Name( "FFL 20508-18DT_CG_100ms" ),
:Name( "EFL 20508-19DT_NOCG_2" ),
:Name( "FFL 20508-19DT_NOCG_2" )
),
Source Label Column( "Label" ),
Stacked Data Column( "Data" ),
Number of Series( 2 )
)
In my script, I have a list variable (MyList1) containing the column names, and I would like to stack those columns using "Multiple Series Stack" to create a new table. Also, for "Number of Series" I would like to include NItems(MyList2). Can someone help me with the syntax?
I think this should work:
StackDT = SplitDT << Stack( Columns( MyList1 ),
Source Label Column( "Source" ),
Stacked Data Column( "Data" ),
Number of Series( NItems( MyList2 ) )
)
);
but it gives me "Column not found in access or evaluation of 'Bad Argument' " in the log.
Data Table( "Untitled 11" ) << Stack(
columns(
:Name( "EFL 20508-17DT_CG_100ms" ),
:Name( "FFL 20508-17DT_CG_100ms" ),
:Name( "EFL 20508-18DT_CG_100ms" ),
:Name( "FFL 20508-18DT_CG_100ms" ),
:Name( "EFL 20508-19DT_NOCG_2" ),
:Name( "FFL 20508-19DT_NOCG_2" )
),
Source Label Column( "Label" ),
Stacked Data Column( "Data" ),
Number of Series( 2 )
)
In my script, I have a list variable (MyList1) containing the column names, and I would like to stack those columns using "Multiple Series Stack" to create a new table. Also, for "Number of Series" I would like to include NItems(MyList2). Can someone help me with the syntax?
I think this should work:
StackDT = SplitDT << Stack( Columns( MyList1 ),
Source Label Column( "Source" ),
Stacked Data Column( "Data" ),
Number of Series( NItems( MyList2 ) )
)
);
but it gives me "Column not found in access or evaluation of 'Bad Argument' " in the log.
10 REPLIES 10
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Stacking Columns in Script
please note that in JMP9 if you fail to generate correctly the list it will crash totally
for example this wil do:
listaNDD = {"5932_NDD","6038_NDD"};
def5932_NDD = {"chips","bubbles"};
def6038_NDD = {"big on top","small on top"};
for(i=1, i<(NItems(listaNDD)+1), i++,
a=listaNDD;
c=Concat(a,"_stacked");
d=Concat("def",a);
Open( Concat(a,".jmp"), invisible );
Open( b, invisible );
Data Table( a ) << Stack(
columns((d)),
Source Label Column( "class" ),
Stacked Data Column( "density" ),
Name( "Non-stacked columns" )(Keep( :Split, :Lot ID, :WID)),
Output Table( c )
);
);
because d it's not the list but a variable containing the name of the list ...
- « Previous
-
- 1
- 2
- Next »