cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
%3CLINGO-SUB%20id%3D%22lingo-sub-781312%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%97%90%20%EC%A0%80%EC%9E%A5%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-781312%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3E%EC%95%88%EB%85%95%ED%95%98%EC%84%B8%EC%9A%94%2C%20%EB%A3%A8%ED%94%84%EB%A5%BC%20%ED%86%B5%ED%95%B4%20FitGroup%EC%97%90%20%EC%97%AC%EB%9F%AC%20%EB%B2%A4%EC%B9%98%EB%A7%88%ED%81%AC%EB%A5%BC%20%EC%83%9D%EC%84%B1%ED%95%98%EB%8A%94%20%EB%8B%A4%EC%9D%8C%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EB%A5%BC%20%EB%A7%88%EC%B9%98%20%22%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%97%90%20%EC%A0%80%EC%9E%A5%22%ED%95%98%EB%8A%94%20%EA%B2%83%EC%B2%98%EB%9F%BC%20%EC%A0%80%EC%9E%A5%ED%95%98%EA%B3%A0%20%EC%8B%B6%EC%9D%80%EB%8D%B0%2C%20%EB%A3%A8%ED%94%84%EC%99%80%20%EB%B9%84%EA%B5%90%ED%95%98%EC%97%AC%20%EB%8F%99%EC%A0%81%EC%9C%BC%EB%A1%9C%20%EC%A0%80%EC%9E%A5%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%80%20%EB%AC%B4%EC%97%87%EC%9D%BC%EA%B9%8C%EC%9A%94%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%2F%2F%20Ouvrir%20la%20table%20de%20donn%C3%A9es%0Adt%20%3D%20Open(%20fichier1%20)%3B%0A%0A%2F%2F%20Initialiser%20une%20liste%20pour%20stocker%20les%20noms%20des%20colonnes%20avec%20la%20note%20%22INGOT%20CHARACTERISTICS%22%0Acols_with_note%20%3D%20%7B%7D%3B%0A%0A%2F%2F%20Parcourir%20chaque%20colonne%20de%20la%20table%20par%20index%0AFor(%20i%20%3D%201%2C%20i%20%26lt%3B%3D%20N%20Cols(%20dt%20)%2C%20i%2B%2B%2C%0A%09col%20%3D%20Column(%20dt%2C%20i%20)%3B%0A%2F%2F%20V%C3%A9rifier%20si%20la%20colonne%20a%20une%20note%20%22INGOT%20CHARACTERISTICS%22%0A%09If(%20col%20%26lt%3B%26lt%3B%20Get%20Property(%20%22Notes%22%20)%20%3D%3D%20%22INGOT%20CHARACTERISTICS%22%2C%20%0A%2F%2F%20Ajouter%20le%20nom%20de%20la%20colonne%20%C3%A0%20la%20liste%0A%09%09Insert%20Into(%20cols_with_note%2C%20col%20%26lt%3B%26lt%3B%20Get%20Name%20)%0A%09)%3B%0A)%3B%0A%0APrint(%0A%09%22Colonnes%20avec%20notes%20trouv%C3%A9es%20pour%20la%20famille%20%22%20%7C%7C%20%22INGOT%20CHARACTERISTICS%22%20%7C%7C%20%22%20%3A%20%22%0A%09%20%7C%7C%20Char(%20cols_with_note%20)%20%7C%7C%20%22%5Cn%22%0A)%3B%0A%0A%2F%2F%20Cr%C3%A9er%20une%20nouvelle%20fen%C3%AAtre%20pour%20regrouper%20tous%20les%20graphiques%0Areport_window%20%3D%20New%20Window(%20%22BenchMarks_Ingot_Characteristics%22%2C%0A%09V%20List%20Box(%0A%09%09Fit%20Group(%0A%09%09%09For(%20i%20%3D%201%2C%20i%20%26lt%3B%3D%20N%20Items(%20cols_with_note%20)%2C%20i%2B%2B%2C%0A%09%09%09%09col_name%20%3D%20cols_with_note%5Bi%5D%3B%0A%2F%2F%20Ajouter%20le%20graphique%20Oneway%20au%20Fit%20Group%0A%09%09%09%09Oneway(%0A%09%09%09%09%09Y(%20Column(%20dt%2C%20col_name%20)%20)%2C%0A%09%09%09%09%09X(%20Column(%20dt%2C%20selection%20)%20)%2C%0A%09%09%09%09%09Quantiles(%201%20)%2C%0A%09%09%09%09%09Means%20and%20Std%20Dev(%201%20)%2C%0A%09%09%09%09%09Box%20Plots(%201%20)%2C%0A%09%09%09%09%09Mean%20Error%20Bars(%201%20)%2C%0A%09%09%09%09%09Std%20Dev%20Lines(%201%20)%2C%0A%09%09%09%09%09X%20Axis%20Proportional(%200%20)%2C%0A%09%09%09%09%09Grand%20Mean(%200%20)%2C%0A%09%09%09%09%09SendToReport(%0A%09%09%09%09%09%09Dispatch(%20%7B%7D%2C%20%22Oneway%20Plot%22%2C%20FrameBox%2C%0A%09%09%09%09%09%09%09%7BDispatchSeg(%0A%09%09%09%09%09%09%09%09Box%20Plot%20Seg(%201%20)%2C%0A%09%09%09%09%09%09%09%09%7BConfidence%20Diamond(%200%20)%2C%20Shortest%20Half%20Bracket(%200%20)%2C%0A%09%09%09%09%09%09%09%09Line%20Color(%20%22Red%22%20)%7D%0A%09%09%09%09%09%09%09)%7D%0A%09%09%09%09%09%09)%0A%09%09%09%09%09)%0A%09%09%09%09)%3B%0A%09%09%09)%0A%09%09)%0A%09)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3Einfo%20col_with_note%EC%97%90%EB%8A%94%20%EB%8B%A4%EC%96%91%ED%95%9C%20%EB%B2%A4%EC%B9%98%EB%A7%88%ED%81%AC%EC%9D%98%20%EC%A2%8C%ED%91%9C%EA%B0%80%20%ED%8F%AC%ED%95%A8%EB%90%98%EC%96%B4%20%EC%9E%88%EC%9C%BC%EB%A9%B0%20%EB%B2%A4%EC%B9%98%EB%A7%88%ED%81%AC%EC%9D%98%20%EA%B0%80%EB%A1%9C%EC%B6%95%EC%9D%84%20%EC%84%A0%ED%83%9D%ED%95%A9%EB%8B%88%EB%8B%A4.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%ED%83%80%EC%9D%B4%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-781312%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CLINGO-LABEL%3E%EC%9E%90%EB%8F%99%ED%99%94%20%EB%B0%8F%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8C%85%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%EB%8D%B0%EC%9D%B4%ED%84%B0%20%EC%A0%91%EA%B7%BC%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%83%90%EC%83%89%20%EB%B0%8F%20%EC%8B%9C%EA%B0%81%ED%99%94%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-781322%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%97%90%20%EC%A0%80%EC%9E%A5%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-781322%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0Adt%20%3D%20current%20data%20table()%3B%0Ajsl%3Ddt%26lt%3B%3CGET%20script%3D%22%22%3E%3C%2FGET%3E%3C%2FCODE%3E%3C%2FPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%0A%3CP%3E%EB%B3%80%EC%88%98%20%22jsl%22%EC%97%90%20%EC%9E%88%EB%8A%94%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%97%90%20%EB%8C%80%ED%95%9C%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EB%A5%BC%20%EA%B0%80%EC%A0%B8%EC%98%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3C%2FCODE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-781326%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%97%90%20%EC%A0%80%EC%9E%A5%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-781326%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%EC%9E%91%EB%8F%99%ED%95%98%EC%A7%80%20%EC%95%8A%EC%8A%B5%EB%8B%88%EB%8B%A4.%20dt(%3Dopen(fichier1))%EC%97%90%20%EC%A0%80%EC%9E%A5%ED%95%98%EA%B3%A0%20%EC%8B%B6%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EB%8F%84%EC%9B%80%EC%9D%B4%20%EB%90%9C%EB%8B%A4%EB%A9%B4%20JMP%2016%EC%9D%B4%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-781340%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%97%90%20%EC%A0%80%EC%9E%A5%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-781340%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2FHow-to-save-the-benchmarks-window-to-the-data-table%2Fm-p%2F780989%23U780989%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-forum-thread%20lia-fa-icon%20lia-fa-forum%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3E%EB%B2%A4%EC%B9%98%EB%A7%88%ED%81%AC%20%EC%B0%BD%EC%9D%84%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%97%90%20%EC%A0%80%EC%9E%A5%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%80%20%EB%AC%B4%EC%97%87%EC%9E%85%EB%8B%88%EA%B9%8C%3F%3C%2FA%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

How to save to data Table but with script

Hello, I would like to save the following script which generates several BenchMarks in a FitGroup via a loop as if I were doing a "save to data table" but dynamically (compared to the loop) how to do it?

 

// Ouvrir la table de données
dt = Open( fichier1 );

// Initialiser une liste pour stocker les noms des colonnes avec la note "INGOT CHARACTERISTICS"
cols_with_note = {};

// Parcourir chaque colonne de la table par index
For( i = 1, i <= N Cols( dt ), i++,
	col = Column( dt, i );
// Vérifier si la colonne a une note "INGOT CHARACTERISTICS"
	If( col << Get Property( "Notes" ) == "INGOT CHARACTERISTICS", 
// Ajouter le nom de la colonne à la liste
		Insert Into( cols_with_note, col << Get Name )
	);
);

Print(
	"Colonnes avec notes trouvées pour la famille " || "INGOT CHARACTERISTICS" || " : "
	 || Char( cols_with_note ) || "\n"
);

// Créer une nouvelle fenêtre pour regrouper tous les graphiques
report_window = New Window( "BenchMarks_Ingot_Characteristics",
	V List Box(
		Fit Group(
			For( i = 1, i <= N Items( cols_with_note ), i++,
				col_name = cols_with_note[i];
// Ajouter le graphique Oneway au Fit Group
				Oneway(
					Y( Column( dt, col_name ) ),
					X( Column( dt, selection ) ),
					Quantiles( 1 ),
					Means and Std Dev( 1 ),
					Box Plots( 1 ),
					Mean Error Bars( 1 ),
					Std Dev Lines( 1 ),
					X Axis Proportional( 0 ),
					Grand Mean( 0 ),
					SendToReport(
						Dispatch( {}, "Oneway Plot", FrameBox,
							{DispatchSeg(
								Box Plot Seg( 1 ),
								{Confidence Diamond( 0 ), Shortest Half Bracket( 0 ),
								Line Color( "Red" )}
							)}
						)
					)
				);
			)
		)
	)
);

 

for info col_with_note contains the coordinates of the different benchmarks and selection the abscissa of the benchmarks

 

Ty

3 REPLIES 3
Byron_JMP
Staff

Re: How to save to data Table but with script

Names Default To Here( 1 );
dt = current data table();
jsl=dt<<get script();

gets the script for the data table in variable "jsl"

JMP Systems Engineer, Health and Life Sciences (Pharma)

Re: How to save to data Table but with script

It didn't work I want to save it to dt (=open(fichier1)). If it could help I have JMP 16

jthi
Super User

Re: How to save to data Table but with script