cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP 19 is here! See the new features at jmp.com/new.
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
Choose Language Hide Translation Bar
cclayton000
Level I

Data entry without JMP?

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 ) ) );

Recommended Articles