Scipters Club Session 4: Data Cockpit - Ways to Enrich a Master Table with Additional Data

maria_astals — Thu, 25 Apr 2024 10:00:40 GMT

Presenter: @Georg

Find the presentation slides here: https://community.jmp.com/t5/Abstracts/Data-Cockpit-Ways-to-Enrich-a-Master-Table-with-Additional-Data/ev-p/708109?profile.language=en

Re: Scipters Club Session 4: Data Cockpit - Ways to Enrich a Master Table with Additional Data

hogi — Sun, 16 Nov 2025 10:24:40 GMT

Agree! The Data Cockpit concept is very powerful

... and, I would argue, unique to JMP.
There is no other program that allows users to access virtually ANYTHING accessible from the local system ( network folders, cloud storage, web pages, logged traces, stored images, ...) with a single mouse click!

Even better: with the new Column Tags in JMP19 one can institutionalize such interactive modules: / @jules

open a web page ? Open an image ? Function( {thisTable, thisColumn, iRow}, Web( thisTable:thisColumn[ iRow ] ) )

open a JMP file? open a folder?
Function( {thisTable, thisColumn, iRow}, open( Char( thisTable:thisColumn[ iRow ] ) ) )

Just store the templates in your preferences and add them to the current data table via:

Set Preferences(
	Column Tags(
		Define Tag( "hogi", Symbol( "🦜" ) ),
		Define Tag( "edit", Symbol( "✏️" ) ),
		Define Tag(
			"web",
			Symbol( "🌍" ),
			Property(
				"Event Handler",
				Event Handler(
					Click(JSL Quote(Function( {thisTable, thisColumn, iRow}, Web( Char( thisTable:thisColumn[ iRow ] ) ) )

)					)
				)
			)
		),
		Define Tag(
			"open",
			Symbol( "📜" ),
			Property(
				"Event Handler",
				Event Handler(
					Click(JSL Quote(Function( {thisTable, thisColumn, iRow}, open( Char( thisTable:thisColumn[ iRow ] ) ) )
)					)
				)
			)
		),

	)
);

Re: Scipters Club Session 4: Data Cockpit - Ways to Enrich a Master Table with Additional Data

hogi — Sun, 16 Nov 2025 10:26:54 GMT

What are further modules which could be institutionalized "globally"?

topic Scipters Club Session 4: Data Cockpit - Ways to Enrich a Master Table with Additional Data in JMP Scripters Club Discussions

Scipters Club Session 4: Data Cockpit - Ways to Enrich a Master Table with Additional Data

Re: Scipters Club Session 4: Data Cockpit - Ways to Enrich a Master Table with Additional Data

Re: Scipters Club Session 4: Data Cockpit - Ways to Enrich a Master Table with Additional Data