Exporting a Table with Spec Limits to Excel

[#1]

I have a JMP data table with embedded Spec Limits and Notes.  Anyone ever export something like that to Excel and retain the Column Properties somehow?

[#2 · Accepted solution]

Hey @SpannerHead ,

You can't directly export the spec limits but you could make a table with JSL and then save that table as an excel table.  If you want to do it without JSL you can use the Manage Limits platform to save out the spec limits to a JMP table and then save that to excel.

Steve

[#3]

To grab the notes, I used this.  I can export this separately to Excel.

dt = Current Data Table();

rej = dt << Get Column Group( "REJ");

notes_list = {};

For( i = 1, i <= N Items( rej ), i++,
	prop = rej[i] << Get Property( "Notes" );
		insert into(notes_list, prop);

);

dt = New Table( "Notes Data" );
dt << New Column( "Parameter", Character, Values( rej ) );
dt << New Column( "Notes", Character, Values( notes_list ) );