topic Re: Make combined data table with script in Discussions

Make combined data table with script

Agustin — Fri, 09 Jun 2023 17:02:37 GMT

Hi I'm using the Variability chart and looking at the variance components. When I right click the Variance components table it gives me the option to make combined data table, is it possible to translate this step to jsl instead of the manual right click?

Thank you

Re: Make combined data table with script

David_Burnham — Tue, 28 Jun 2022 15:52:00 GMT

Do it manually and take a look at the table that is produced. It will contain a table script which contains the JSL to produce the same outcome.

Re: Make combined data table with script

Agustin — Wed, 29 Jun 2022 10:13:47 GMT

Hi David, how do I look at the table script? I tried using the log functionality but it didn't show anything.

Thanks

Re: Make combined data table with script

Agustin — Wed, 29 Jun 2022 10:30:36 GMT

Hi I found what you meant however when I try to run it this error comes up:

Names Default To Here( 1 );
platform = Data Table(
	"table"
) << Variability Chart(
	Y( :measurement ),
	X( :Lot, :Instrument, :Operator, :Site ),
	Model( "Main Effect" ),
	Variance Components( 1 ),
	SendToReport(
		Dispatch(
			{"Variance Components"},
			"CV",
			NumberColBox,
			{Visibility( "Visible" )}
		)
	)
);
Wait( 0 );
Report( platform[1] )[Outline Box( "Variance Components" )][Table Box( 1 )] <<
Make Combined Data Table;
Report( platform[1] ) << Close Window;

That's the code for reference, firstly it's missing several variability charts, but even when I add them manually the same error pops up. Any ideas?

Re: Make combined data table with script

Agustin — Wed, 29 Jun 2022 10:54:31 GMT

This fixed it:

platform[1][Outline Box( "Variance Components" )][Table Box( 1 )]<<
Make Combined Data Table;