Welcome to the 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, loc1 ); If( offset, txt = Substr( txt, offset, Length( txt ) ) ); loc2 = "}]"; offset = Contains( txt, loc2, -1 ); If( offset, txt = Substr( txt, 1, offset + 1 ) ); d1 = JSON To Data Table( txt );//without going through a "d1" file.
  How to write the...

  lwx228

  Discussions |

  Apr 2, 2021 4:18 PM

  1545 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 subsets, and each subset contains 1105 ID lines.Could you please help me to find the solution?I attached the part of the dataset. 

  giaMSU

  Discussions |

  Apr 2, 2021 2:45 PM

  1368 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 Calc - Data1" ) )
  With the resulting table looking like this For Calc - Data1Data11212 12 123333 33     However I can't apply this same formula to a column that has strings or characters to result in the following data table because I get an error sa...

  user8421

  Discussions |

  Apr 2, 2021 1:49 PM

  1552 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 B02/08/2021 11:45 AMA1B102/08/2021 1:39 PMA2B202/08/2021 11:37 PMA3B302/13/2021 12:01 AMA4B402/13/2021 4:00 PMA5B502/13/2021 10:22 PMA6B602/18/2021 9:00 AMA7B702/18/2021 12:01 PMA8B802/21/2021 9:15 AMA9B902/21/2021 11:50 AMA10B1002/21/2021 3:00 PMA1...

  user8421

  Discussions |

  Apr 2, 2021 11:20 AM

  6933 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, // comment xyz    <foldable code block 2 > );   But often, the first block will catch later blocks and fold them all together.   The code work without a problem, but is is sometimes hard to find the code, it is lost in the folds. Is there a solution to t...

  mann

  Discussions |

  Apr 2, 2021 8:36 AM

  2787 views | 5 replies