cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to create experiments to support product design and ID useful product features. Register for June 12 webinar, 2pm US Eastern Time.

JMP Scripters Club Discussions

Choose Language Hide Translation Bar

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

Presenter:  @Georg 

 

(view in My Videos)

 

Find the presentation slides here: https://community.jmp.com/t5/Abstracts/Data-Cockpit-Ways-to-Enrich-a-Master-Table-with-Additional-Da...

 

2 REPLIES 2
hogi
Level XIII

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

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:Everyday Efficiency: Making Data Smarter. Making Smarter Data. / @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:

hogi_1-1763288665528.png

 

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 ] ) ) )
)					)
				)
			)
		),

	)
);

hogi_0-1763287827201.png

hogi
Level XIII

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

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