JMP User Community

Latest Discussions

JSL script to filter out entire rows where a particular column contain missing values

Dear Community, i am a beginner user and would like to request your kind help with my following code. The argument of the "is missing" function seems incorrect. I d like the script to show a table where rows that contains values in certain ranges are displayed. Also, the rows with empty cells in the two columns used for the filtering are to be excluded. Here goes the code: dt = Current Data Ta...
Michal

Discussions |
Mar 24, 2024 6:36 AM

2444 views | 4 replies
expression column with list compare to given list to replace with desired value

Hi,is there a method through add new formula to column for issue below?

I have a column that is list value and I want to compare to given list, if element from list in column match to given list then replace that single element with "1". Below are example. The given list is {"aa", "app", "b", "pp", "zzzz"}
dadawasozo

Discussions |
Mar 23, 2024 10:59 AM

1613 views | 3 replies
Using journal to produce graph builder plots

Hi, I'm using journal to produce graph builder histogram distributions. The issue that I'm having is that sometimes the last one or two plots, get compressed and some settings are lost, such as increment which makes the plot unclear. I tried manipulating the size of the graph builder and all plots changes accordingly besides the last two or sometimes last plot. Any recommendations regarding this ...
RA899

Discussions |
Mar 23, 2024 9:16 AM

881 views | 1 replies
Error installing JMP 16

Hi All, Here is the error I got.
OS: Windows 10 proI have installed this previously until today
RMSETurtle754

Discussions |
Mar 22, 2024 5:26 PM

1010 views | 1 replies
Problem calling a script with Include()

Hi All, I have 3 scripts that run different SQL queries to extract data. Another script uses Include() to run each one of those scripts and then makes some modifications to the three tables and joins them.In two of those scripts, when I run the individual script, or the call using Include(), I got the same table. However, for the last script, if I run it I get like 8000 rows, but running it throug...
Festrus

Discussions |
Mar 22, 2024 7:41 AM

1667 views | 3 replies

Previous
Next

Latest Discussions

expression column with list compare to given list to replace with desired value

Hi,is there a method through add new formula to column for issue below?

I have a column that is list value and I want to compare to given list, if element from list in column match to given list then replace that single element with "1". Below are example. The given list is {"aa", "app", "b", "pp", "zzzz"}
dadawasozo

Discussions |
Mar 23, 2024 10:59 AM

1613 views | 3 replies
Using journal to produce graph builder plots

Hi, I'm using journal to produce graph builder histogram distributions. The issue that I'm having is that sometimes the last one or two plots, get compressed and some settings are lost, such as increment which makes the plot unclear. I tried manipulating the size of the graph builder and all plots changes accordingly besides the last two or sometimes last plot. Any recommendations regarding this ...
RA899

Discussions |
Mar 23, 2024 9:16 AM

881 views | 1 replies
Error installing JMP 16

Hi All, Here is the error I got.
OS: Windows 10 proI have installed this previously until today
RMSETurtle754

Discussions |
Mar 22, 2024 5:26 PM

1010 views | 1 replies
Problem calling a script with Include()

Hi All, I have 3 scripts that run different SQL queries to extract data. Another script uses Include() to run each one of those scripts and then makes some modifications to the three tables and joins them.In two of those scripts, when I run the individual script, or the call using Include(), I got the same table. However, for the last script, if I run it I get like 8000 rows, but running it throug...
Festrus

Discussions |
Mar 22, 2024 7:41 AM

1667 views | 3 replies
How to calculate date from cumulative data?

I have a script that is pulling data from a server everyday. It has a date column from August-present. How can I get which data is from 2 Quarters or 3 Months or 4 Weeks or 10 Days starting from the present day from the data? This calculations should be in separated columns like. And I think a flag will be needed? And is it possible to continuously calculate this using the latest added date? I'm n...
UserID16644

Discussions |
Mar 21, 2024 10:28 PM

1006 views | 1 replies

Previous
Next

Latest Discussions

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
DataTable Prompt in application builder on module load

Hello guys, I have applciation builder with multiple modules. one of the module only contains column list which requires selection of datatable. How to make jmp prompt to select datatable only when that module loads.By default it prompts when the application loads Kindly guide. Thanks in advance
ComplexNerd

Discussions |
Mar 7, 2024 3:54 AM

662 views | 0 replies
JMP Project Global Data Filter and Column Switcher

Hello Guys, I just started exploring jmp project. I am wondering if there is any option to add Global Data Filter and a global column switcher to a jmp project.Currely i have created a jmp project with various reports from a datatable (similar to dashboard) but i want to know if there is a option to add a global data filter and also a global column switcher to this screen. My idea : To create a sc...
ComplexNerd

Discussions |
Mar 7, 2024 12:10 AM

621 views | 0 replies
"If" returns error response

I have a script to draw charts and use "if" for the reference line."Sometimes" the reference line is not correct. For example, when Rel_Test=H3TRB, the reference line should be 10, but it shows 5.How could I fix it? d6_graph=dt2 << Graph Builder( Size( 400, 300 ), Show Control Panel( 0 ), Variables( X( :Lot), Y( :dIGSS, Position( 1 ) ), Color( :Lot ), By(:Rel_Test) ), Elements( Box Pl...
LT

Discussions |
Mar 4, 2024 8:08 PM

942 views | 0 replies
Neural networks that learn and predict in real time (incremental learning)

Hello community!!A query:- How JMP is configured to generate neural networks that learn from their inputs in real time (incremental learning) in such a way that it continually updates its weights according to new inputs and generates updated real-time predictions.Greetings,Marco
Marco2024

Discussions |
Mar 4, 2024 9:37 AM

850 views | 0 replies