Subscribe Bookmark RSS Feed
brady_brady

Staff

Joined:

Jun 9, 2012

Data Table Tools Add-in

This addin contains several utilities for working more efficiently with data tables. With it, you can:

 

  • Quickly set the number of decimal places displayed in the data table.
  • Set and change column widths in bulk.
  • Perform customized reordering and sorting of columns in bulk.
  • Convert value labels to the equivalent strings.
  • Push and pull column names to and from tables in bulk.
  • Lock and unlock tables and columns in bulk.
  • Create random categorical and correlated normal data.
  • Get data from any JMP report table.
  • Get (x,y) points from any graph within a JMP report.
  • Click on an image to record (x,y) points.
  • Span or interpolate over empy cells.
  • Create custom date formulas using an intuitive interface with drop-down menus.
  • Number rows in their order of occurrence within specified groups.
  • Create a column whose values are 1 when the row is selected and 0 otherwise.
  • Concatenate multiple files (text, JMP or excel) from a folder (optionally, its subfolders as well) into a single .jmp table.
  • Concatenate a table with itself any number of times.
  • Sample table rows with or without replacement.
  • Convert between multiple-response and stacked formats.
  • Expand a table using frequency counts (unsummarize rows).

 

Many of these features will be described in more detail in JMP blogs. Some will also be available as stand-alone add-ins. As it becomes available, supporting documentation will also be uploaded to this page.

 

Enjoy!

Brady

Comments

Cool beans!  Thank-you!

tejvishnu

Extremely useful and what a time-saver this has been. Have used this add-in already today! Thank you..

tajrida

A PDF help file with examples will be good to understand and use this add-in

alxh

Utterly fantastic, thank you!

brady_brady

@tajrida,

 

I agree. The problem is that .pdf and .docx files cannot currently be uploaded--I am not sure why, but this happened after the infrastucture switch. When this is remedied, I will get the documents posted, as I blog about them. Right now the only document that is written is the one for the custom date formula writer.

 

Thanks,

Brady

quest74

can I download this add in for JMp11

Olaf
"Push column names" does not allow to select the "column of column names" resulting in Error "Ensure selections are made in all 3 panes". It is empty. What am I missing?
brady_brady
Did you press the “Refresh table list” button in the upper left of the window? Once this has been done, you should be able to:

1. Select the new table in the upper left list box (it will not appear until you refresh the name list; for reasons I won’t get into here, the name list does not refresh itself automatically)
2. Select the column of column names in the lower left list box
3. Select the table into which you will push these names
4. Check or uncheck options, as appropriate
5. Press the “Push Names” button

Cheers,
Brady
Olaf

Thanks for responding Brady,

I did refresh the list and even started the add-in and JMP over again.

But that did not help either. Tested on multiple files.

Using 13.2.0 on Mac and latest add-in.

Regards, Olaf

P.S.

I recorded a little video showing what I did and how the problem presents to me, but uploading here requires some version of flash that is not installed on our systems (working on windows right now).

Olaf

Same on win JMP 13.1.0

brady_brady

Olaf, will you please shoot me an email directly? I will need to troubleshoot the app, I'm afraid. Perhaps some surgery will be required.

 

Cheers,

Brady

Article Labels
Article Tags
Contributors