cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Dyan
Level I

With multiple Data Table how do i link it such that each time i rerun it will choose the correct one.

Hi all, I have a JMP script which generates a Journal with different plots using different data tables. Using the journal how can i rerun the plot without having to choose which data table to use.

 

 

For( i = 1, i <= N Items( colPlotType ), i++,
	/* SET THE CURRENT DATA TABLE TO THE APPROPRIATE REPORT TYPE */
	If( 
		/* IF REPORT TYPE IS PD*/
		colReportType[i] == "PD",
		/* THEN */
		If(
			Is Empty( partdata_table ) != 1,
			current_table = partdata_table;
			Current Data Table( partdata_table ),
			
			Continue()
		),
		
		/* IF REPORT TYPE IS ICC*/
		colReportType[i] == "ICC",
		/* THEN */
		If(
			Is Empty( icc_table ) != 1,
			current_table = icc_table;
			Current Data Table( icc_table ),
			
			Continue()
		),
);


The snippet script above is how im linking the different data table to each plot to generate the plot. 

 

The flow:

1) Opens and read csv file 

2) each row in csv file does a plot according to colReportType[i] 

3) if colReportType[i] == "ICC",  then it will use the icc data table.

1 REPLY 1
StarfruitBob
Level VI

Re: With multiple Data Table how do i link it such that each time i rerun it will choose the correct one.

Hello @Dyan ,

 

My best guess would be to embed a script that deletes the current plot, regenerates the desired plot from the desired table, and then insert it back into the journal. If I understand journals correctly, they're supposed to be static. Therefore an "update" to an element of it can only be done by removal of it, and then insertion of the updated element.

Learning every day!