topic Table Update: Transformed value in Discussions

Table Update: Transformed value

hogi — Thu, 08 Jun 2023 16:41:32 GMT

In the Tables/Update menu, the user has the possibility to define new formulas o the fly by right clicking into a columns menu and selecting the transformation of choice.

Somehow strange: the newly defined column is not added to the table (nor to the preview - see screenshot).

Could somebody reproduce he behavior - and suggest what I have to change in the menu such that the newly defined column gets added?

Open( "$SAMPLE_DATA/Big Class.jmp" );

tmp = Data Table( "Big Class" ) << Summary(
	Group( :name ),
	Freq( "None" ),
	Weight( "None" )
);

Data Table( "Big Class" ) << Update(
	With( tmp ),
	Match Columns( :name = :name ),
	Add Columns from Update Table(
		:N Rows,
		Transform Column(
			"1/N Rows",
			Format( "Fixed Dec", 12, 0 ),
			Formula( 1 / :N Rows )
		)
	)
);

Re: Table Update: Transformed value

Jed_Campbell — Wed, 25 Jan 2023 15:59:41 GMT

I was able to duplicate this behavior. The column is not added, even if I right click in the platform dialog box and select "Add to Data Table." I have a feeling that the behavior we're seeing is not what's intended.

One workaround would be to add the transformed column before running the Update script.

Re: Table Update: Transformed value

hogi — Wed, 25 Jan 2023 16:29:22 GMT

OK, I informed Jmp support.
case: TS-00032949

Re: Table Update: Transformed value

hogi — Thu, 26 Jan 2023 16:55:59 GMT

@Jed_Campbell thank you for the workaround. It also works directly in the update menu - via Right Click/Add to Data Table.

The only thing: Due to the table update when the column is added to the table, the column gets deselected in the list of selected columns.

After selecting "it" (non-italic version) again, it gets also added in the preview. (jmp 17).

same on your site?

But in general, this behavior differs significantly from the behavior of e.g. Summarize.

In Summarize I don't have to add Transform Columns to the table such that they can be used in the menu.

Let's see how it will look in jmp 18 ...

Re: Table Update: Transformed value

Jed_Campbell — Thu, 26 Jan 2023 22:04:31 GMT

Yes, I'm seeing the same.

Let's see how it will look in jmp 18 ...

:thumbs_up: