JMP Table Script Not Including Column Expression

LeeP

I'm trying to automate my JMP chart creation. I've been using  the following as a guide: Automated Report Creation From Data Import to Publication 2019

I've gotten to the point where I create the table from a SQL Query. I had to add a new column to the table which is an expression. The issue is that I can't get the script to show this calculated column. When I right click "Modify Query" it only shows the base query and not the calculated column. How do I get the script that includes the calculated column?

Mark_Bailey

The table scripts are created with the result of the query. They do not capture any changes to the data table afterward such as adding the data column with the ratio calculation.

 

I added the code to create this column for you and appended it to the end of the Modify Query script. It is for proof of principle.

 

Names Default To Here( 1 );

dt = New SQL Query(
	Connection( "CONNECTION HERE" ),
	QueryName( "ON_TIME_SPC" ),
	Select(
		Column( "ReleaseMonth", "t1", Numeric Format( "m/d/y", "-1", "NO", "" ) ),
		Column(
			"On-Time",
			"t1",
			Alias( "Sum-On-Time" ),
			SavedJMPName( "On-Time" ),
			Aggregation( "Sum" ),
			JMP Name( "Sum-On-Time", 0 )
		),
		Column(
			"Total",
			"t1",
			Alias( "Sum-Total" ),
			SavedJMPName( "Total" ),
			Aggregation( "Sum" ),
			JMP Name( "Sum-Total", 0 )
		),
		Column( "Phase", "t1", Analysis Type( "Nominal" ) )
	),
	From( Table( "ON_TIME_SPC", Schema( "dbo" ), Alias( "t1" ) ) ),
	Group By(
		Column( "ReleaseMonth", "t1", Numeric Format( "m/d/y", "-1", "NO", "" ) ),
		Column( "Phase", "t1" )
	)
);

dt << New Column( "OnTimePct",
	Formula( :Name( "Sum-On-Time" ) / :Name( "Sum-Total" )
);

I save a reference to the new data table in the variable dt so I can send messages. I send the << New Column() message to create the column with the ratio.