Subscribe Bookmark RSS Feed
Justin_Chilton

Joined:

Aug 27, 2015

Table Attributes Add-In

Description

 

Have you ever needed to share data and collaborate with a colleague who is not a JMP user?  Perhaps you export data to Excel for those colleagues, only to lose the JMP formulas, table scripts, and other column properties when you bring the updated data back to JMP.  This add-in enables you to export a JMP data table to an Excel workbook along with the table and column properties of the original JMP table in a separate worksheet. Your colleague can then update or modify the data to send back to you.  When you import the workbook back into JMP, all of your table scripts, column properties, and even column formulas will be automatically restored.  This Add-In will also allow you to generate an attribute table for any JMP data table.

Menu Items

Menu Items2.png

 

JMP Attribute Table

Create an attribute table for the current data table.

JMP Attribute TableJMP Attribute Table

Add Attribute Table Script

Add a script to the current data table that will create an attribute table.

 Table Script.png

 "Create Attribute Table" Table Script"Create Attribute Table" Table Script

Export Workbook with Attributes

Export table(s) to an Excel workbook with sheets for column and table attributes.

 

 Export Workbook DialogExport Workbook Dialog

Exported Excel WorkbookExported Excel Workbook

Import Workbook with Attributes

Import table(s) from an Excel workbook with all column properties and table variables/scripts.

 Import Workbook DialogImport Workbook Dialog

 Check out my blog post JMP to Excel and back again -- all without losing any table attributes

 

NOTE: This add-in is only supported for JMP 13 (and future versions of JMP).

 

UPDATE: Version 1.1 (June 20, 2017)

Changelog:

  • Fixed issue where you get an error when canceling the selection of a data table.
  • Fixed issue where character columns with a formula caused an extra column to be created in the attribute table
  • Fixed issue where validation column properties caused an error when importing the a table.

UPDATE: Version 1.2 (June 21, 2017)

Changelog:

  • Added support for Mac operating systems.
  • Added a prompt when file being overwritten is locked by another process.

UPDATE: Version 1.3 (June 27, 2017)

Changelog:

  • Made a change so that progress bar appears when export process takes a while. Also, an alert message now appears when there are more rows in the data table than Excel supports within a single sheet.

UPDATE: Version 1.4 (November 21, 2017)

Changelog:

  • Added support for all** column properties.
    **Let me know if there's one that does not work, as I did not test them all.
Comments
jenkins_macedo

 What do you do in the event that the number of rows of the original JMP Data Table exceeds the maximum allowable number of rows that an Excel spreadsheet can take this is usually around 1 million and everything else gets dump into another Excel Spreadsheet. if that happens how is that going to affect your analysis?

Justin_Chilton

Hi @jenkins_macedo,

This add-in uses the Create Excel Workbook() JSL function to export to Excel. This is the same JMP functionality that can be found by clicking View > Create Excel Workbook. This function actually causes the data to be truncated in the output workbook.

In the previous version of this add-in (v1.2), there is a message written in the log that explains that the data has been truncated. I have updated the add-in file on this post so this message is now exposed in a JMP window.

I will look into adding the capability to split this data into multiple sheets in a future version.

Thanks,

Article Labels
Article Tags
Contributors