cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
See how to use to use Text Explorer to glean valuable information from text data at April 25 webinar.
Choose Language Hide Translation Bar
View Original Published Thread

Data entry without JMP?

cclayton000
Level I

We are new to JMP and expanding its usage.  Currently, there is two distinct users for JMP:  Statical Analyst People and Data Entry Only People.  There is a thought that the only way to get new data added to JMP is for Data Entry to be performed directly to the JMP file itself.  Therefore, there would be several people that need the JMP software merely to add rows of data.  This seems to be a waste of money. 

 

My Question:  does JMP have any method where the data entry can be performed on the side in an Excel spreadsheet, SQL, SharePoint Form, etc. instead of adding data directly?

 

I'm envisioning a JMP file that is linked to a excel file or database that merely pulls in any new entries added to the source data.  Thoughts?

 

Regards,


Chris

10 REPLIES 10
hogi
Level XII


Re: Data entry without JMP?

As an example, how can I trigger an update for this modified data table?

 

dt = Open( "$SAMPLE_IMPORT_DATA/Restaurant Tips.xlsx" );
:Number of Guests << set name( "N Guests" );
dt << add rows( {Bill Amount = 22.50, Tip Amount = 2, Credit Card = "y"} );
dt << New Column( "additional column", Character, set each value( Left( Char( :Bill Amount ), 2 ) ) );