How to keep Cell Color of JMP table when Concatenating Tables

billkopp

In a JSL I have several tables with some cells colored. Is there an option that will preserve the custom colored cells in the concatenated table.

In this example, the colors in dtFTSplit1 are lost.

dtFTDetails << Concatenate( dtFTSplit1, append to first table )

txnelson

I am not aware of any option that allows the retaining of the cell colors during a concatenation.  In fact, just getting the cell colors is not a straight forward thing.  In the past, I have handled this by examining the script for a given table, and then interrigating the script to get the cell colors and then applying that to the correct columns in the new data table.

/**************************************************************************/
/* Get the color specified for a column                                   */
/*                                                                        */
/* There is not a direct way in JMP to get the color(s) that have been    */
/* specified for a given column.  However, one can ask JMP to provide     */
/* a script that will recreate a column, and within that script, the      */
/* color(s) can be found.                                                 */
/*                                                                        */
/* An Example Column's Script:                                            */
/*                                                                        */
/*   New Column( "From",                                                  */
/*	 Numeric,                                                             */
/*	 Continuous,                                                          */
/*	 Format( "Best", 6 ),                                                 */
/*	 Value Labels( {9999 = "All Fail", 99999 = "All Fail",                */
/*     999999 = "All Fail"} ),                                            */
/*	 Use Value Labels( 1 ),                                               */
/*	 Color Cells( {5, {0}} ),                                             */
/*	 Set Values(                                                          */
/*		[1, 13.09, 12.4, 11.74, 614000000, 614000000, 614000000,          */
/*      614000000, 614000000, 614000000, 614000000, 614000000,            */ 
/*      614000000, 614000000, 614000000, 614000000, 614000000,            */
/*      614000000, 614000000, 614000000, 614000000, 614000000]            */
/*	    )                                                                 */
/*    )                                                                   */
/**************************************************************************/