JMP User Community

Latest Discussions

Using JSL to download Web JSON data, can be directly written into the matrix?

A table in all digital format can be downloaded using the following JSL.u = "http……"; txt = Load Text File( u ); loc1 = "[{"; offset = Contains( txt,...
lwx228

Discussions |
Apr 2, 2021 4:18 PM

907 views | 2 replies
Create subsets from huge table (3,632,135 rows)

Hi all, I have a big dataset with more than 3 million rows. The table contains 1105 ID (0-1104). Each ID has 3287 rows. So, I want to create 3287 subs...
giaMSU

Discussions |
Apr 2, 2021 2:45 PM

851 views | 1 replies
How to repeat values in a column when they are strings

Hi everyone!

I've used this script below for numerical values If( Is Missing( :Name( "For Calc - Data1" ) ), Lag( :Name( "Data1" ), 1 ), :Name( "For...
user8421

Discussions |
Apr 2, 2021 1:49 PM

916 views | 1 replies
How do I join two tables based on timestamps that don't exactly match?

Hi everyone! I am having an issue where I have Data Table 1 as shown below with a timestamp column and various columns of data TimestampColumn AColumn...
user8421

Discussions |
Apr 2, 2021 11:20 AM

4410 views | 5 replies
Code Folding is catching too many lines

I have set "if" blocks to be foldable, and I have been using them like this If (1==1, // comment abc <foldable code block 1 > ); If (1==1, // c...
mann

Discussions |
Apr 2, 2021 8:36 AM

1391 views | 5 replies

Using JSL to download Web JSON data, can be directly written into the matrix?

A table in all digital format can be downloaded using the following JSL.u = "http……"; txt = Load Text File( u ); loc1 = "[{"; offset = Contains( txt,...
lwx228

Discussions |
Apr 2, 2021 4:18 PM

907 views | 2 replies
Create subsets from huge table (3,632,135 rows)

Hi all, I have a big dataset with more than 3 million rows. The table contains 1105 ID (0-1104). Each ID has 3287 rows. So, I want to create 3287 subs...
giaMSU

Discussions |
Apr 2, 2021 2:45 PM

851 views | 1 replies
How to repeat values in a column when they are strings

Hi everyone!

I've used this script below for numerical values If( Is Missing( :Name( "For Calc - Data1" ) ), Lag( :Name( "Data1" ), 1 ), :Name( "For...
user8421

Discussions |
Apr 2, 2021 1:49 PM

916 views | 1 replies
How do I join two tables based on timestamps that don't exactly match?

Hi everyone! I am having an issue where I have Data Table 1 as shown below with a timestamp column and various columns of data TimestampColumn AColumn...
user8421

Discussions |
Apr 2, 2021 11:20 AM

4410 views | 5 replies
Code Folding is catching too many lines

I have set "if" blocks to be foldable, and I have been using them like this If (1==1, // comment abc <foldable code block 1 > ); If (1==1, // c...
mann

Discussions |
Apr 2, 2021 8:36 AM

1391 views | 5 replies