JMP User Community

Latest Discussions

Open file from private github repository (authentication needed)

I would like to open a jmp table stored on github in a private repository (that my user account has access to). So how do I web open a file that needs authentication?
pauldeen

Discussions |
Jul 29, 2024 1:52 PM

2825 views | 6 replies
How to line up each field?

I have txt file. I would like to import to JMP to analysis. But some columns are not line up. How do I line up them?The delimited should be space, spaces and comma. But ", " will treat space as text. How do I overcome this problem?dtTlog = Open( D, Import Settings( End Of Line( CRLF, CR, LF ), End Of Field( Spaces, Space, CSV( 1 ), Comma ), Strip Quotes( 1 ), Use Apostrophe as Quotation...
Victor3

Discussions |
Jul 29, 2024 2:19 AM

3425 views | 6 replies
Set File List with a variable during Multiple File Import

I'm using JMP 18.0.1 and I noticed the new option for Multiple File Import that allows the user to provide a list files (or directories) to import. I can successfully use it in a script like so: Multiple File Import( <<Set Use File List( 1 ), <<Set File List( { "C:\file1.csv", "C:\file2.csv", "C:\file3.csv" } ), <<Set Import Mode( "CSVData" ), <<Set Stack Mode( "Stack Similar" ), ) << Import...
simopod

Discussions |
Jul 27, 2024 12:07 AM

1058 views | 1 replies
Close Invisible Tabulate Window

I am using Tabulate to summarize some data in a script and then saving the result to a table. I use the "invisible" property (command or whatever it is) so I don't see the intermediate Tabulate window. However, I end up with a bunch of invisible Tabulate windows that accumulate as I run through the script. See image below... I tried dtab << Close but it doesn't work. Can someone tell me how to c...
scott1588

Discussions |
Jul 26, 2024 7:46 AM

1509 views | 2 replies
Interactive / Dynamic Filtering or Choice Menu

I have a table named dt. I take the unique values of some columns and I create the following menu that gives the ability to the end user to filter the dt table based on the values of the columns and take a subset of this.
However, taking the unique values of its column is risky because you may end up choosing a combination of attributes that doesn't exist in the table.

Is there any way to make this...
Georgios_Tsim

Discussions |
Jul 26, 2024 2:12 AM

1668 views | 4 replies

Previous
Next

Latest Discussions

Open file from private github repository (authentication needed)

I would like to open a jmp table stored on github in a private repository (that my user account has access to). So how do I web open a file that needs authentication?
pauldeen

Discussions |
Jul 29, 2024 1:52 PM

2825 views | 6 replies
Set File List with a variable during Multiple File Import

I'm using JMP 18.0.1 and I noticed the new option for Multiple File Import that allows the user to provide a list files (or directories) to import. I can successfully use it in a script like so: Multiple File Import( <<Set Use File List( 1 ), <<Set File List( { "C:\file1.csv", "C:\file2.csv", "C:\file3.csv" } ), <<Set Import Mode( "CSVData" ), <<Set Stack Mode( "Stack Similar" ), ) << Import...
simopod

Discussions |
Jul 27, 2024 12:07 AM

1058 views | 1 replies
How to select the right data table to create a dashboard in a JMP Project

I have a long script where in the first part different data tables are joined together and some calculations are made. The result of this part are 3 data tables and several graphs in one of the data tables. The second part of the script would create a dashboard from the already made graphs/plots. If I run the script it makes an empty dashboard, but if I run the first part then select the data tabl...
IloinenHamsteri

Discussions |
Jul 26, 2024 2:07 AM

860 views | 1 replies
Import Unpopulated Excel Data

I am writing a script that will import an excel sheet and perform various cleaning and analysis actions on it. However, the excel sheets that will be imported are updated daily and have 20,000+ rows that will only populate when you refresh it in excel. I have not been able to find a way to refresh this data sheet in the excel import wizard or in JMP without going into the excel sheet and refreshin...
S_Boilermaker

Discussions |
Jul 25, 2024 9:53 AM

1284 views | 2 replies
Have an ANOM report grouped by a column hence has multiple summary reports. How do I extract each summary report into a data table ?

kd_kel

Discussions |
Jul 24, 2024 10:03 PM

1590 views | 3 replies

Previous
Next

Latest Discussions

Tracking down a cycle error

When I open a data table, I get a cycle detected error that I have to ignore every time. I can't seem to figure out what is causing the error although it apparently has something to do with the table variable in my column formula. Here is the formula: and here is the log entry showing the issue Can anyone help me understand what is going on here? The data table actually works fine after I click ...
scott1588

Discussions |
Jun 24, 2024 11:47 AM

1098 views | 0 replies
How do I make scattorplot Matrix with multiple cloumns I select?

Hi. I'm Jeon.I'm beginner of JMP. I want to have a script for making scattorplot Matrix with Items I select.Could you give me a help with it? I splited one data table to two data table. one has value of test items(*Data type : Numeric & Continuous) , another one has upper limit & lower limit.(*Charactor & Norminal) Column names(=test item names) are the same in 2 different data table. Two sample d...
NagneTE1

Discussions |
May 27, 2024 5:18 PM

784 views | 0 replies
graph builder bug - x group shift

(JMP 17, MacOS) I have a JSL scripts that creates multiple graph builder charts, but in some of them, and it's not repeatable always - some of the x groups are getting different height, causing also the data plotted to be shifted. Another issue - is that I can't set the X group lables text to be 90 degrees rotated to fit long strings without making the chart too wide. This is supported for X var...
ShlomiB76

Discussions |
Apr 14, 2024 12:08 AM

720 views | 0 replies
Project ignoring H Splitter Box Set Sizes . . . sometimes

I'm working with a JMP 17 Project and have a script to import a CSV file, embed a script into the Data Table, and execute the embedded script. The embedded script creates a graph from the data and sets the Project layout. All of these pieces, executed individually, work as intended. The problem I am having is that when I execute the combined script, the outer H Splitter Box ignores <<Set Sizes and...
ionatx

Discussions |
Apr 4, 2024 1:25 PM

709 views | 0 replies
Error during stemming in text explorer: Inconsistent Recodes in access or evaluation of 'List'

Hello Community! I'm trying to recode the stemming in text explorer based on a fixed dictionary of words and I'm getting this error "Inconsistent Recodes in access or evaluation of List". This is my code: obj = dt << Text Explorer( Text Columns( :col1) ); obj << Stemming("Stem for Combining"); obj << Add Recodes( {{"attractive", "Attract"},{"unattractive", "Attract"},{"attract", "Attract"},{"ugl...
sm3001

Discussions |
Mar 21, 2024 12:49 AM

932 views | 0 replies