Reading Excel file - column with numeric and character values
I am reading Excel file with JSL, first 2000 rows of column are numeric, followed by rows with characters. How do I make sure the column is read as character?
gfirmstoneFind courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesI am reading Excel file with JSL, first 2000 rows of column are numeric, followed by rows with characters. How do I make sure the column is read as character?
gfirmstoneI would like to migrate my add-in development to github and enable easy updating. If I push code, a github action should run that zips the source folder up and creates the latest.jmpaddin in the ro...
pauldeenI am trying to pre-filter a Query based on date range, but can't figure out how to get it to work. I keep getting this error. I have to be missing something simple, right?
Phil_NashI am trying to duplicate, in jmp, extracting the week from a date column that I pull in Excel with the following formula, =TEXT(A2,"YYYY")&"-"&TEXT(WEEKNUM(A2,2),"00"). The resulting week is ...
WoHNYHello everyone, I would like to know how to count the number of "OTPs" that are equal to 0 and make the division on the total number of LINES of OTP ? Thank you for your help
NetflixCrow956I am trying to duplicate, in jmp, extracting the week from a date column that I pull in Excel with the following formula, =TEXT(A2,"YYYY")&"-"&TEXT(WEEKNUM(A2,2),"00"). The resulting week is ...
WoHNYDear JMP Community, I am new to JMP and wanted to build a widget which would allow sliding spec limits and resulting yield assessments for a product. Such a capability can be super helpful f...
DataComHello! Does JSL have modules for text encryption and decryption? Thanks! AHK String(AlgId, Mode := "", String := "", Key := "", IV := "", Encoding := "utf-8", Output := "BASE64")
lalaHi Folks, I'm troubleshooting an issue with some JMP queries and I've discovered I can see and access the required Oracle tables within a schema when I open the tables using the Database/Open Table o...
BrendanMIf I run the Fit Modelplatform, the "Combined Prediction Profiler" in the resulting Fit Group has pink shadings that indicate the factor's importance. Now I save the Fit Group, either using Save As, ...
TheDudeHi All, I have what seems to be an odd problem. I've created a JSL script that launches a window through which a user can select some options and then run scripts to pull data from various s...
jbakriHi everyone, I have used the choice model platform to design and analyse choice experiments. However, at the analysis step, there are some parts of JMP platform output that are not clear, and I wond...
gav2013JMP Education is offering upcoming classes with a live instructor. Links go to the page in the course catalog with more information and a link to register. July 26-29: JMP: Reliability Analysis for...
Di_MichelsonDear All, I have been analysing a two factorial (3*4) RCBD repeated measures design by using the mixed model approach in JMP. Above is a section of the report I got. Why are the estimates zero. Othe...
MomentMonster90Is there a better way rather than iteration of all the rows to validate values in column? Let's say before making something with the column I want to make sure that all values in column matc...
miguelloREGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/jmp101-28aug2024.html ...
This webinar is in English, 2:00 p.m. US Eastern Time. Learn how to publish data, dashboards...
REGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/teaching-univar-11sep2024.htm...
https://www.jmp.com/en_us/events/users-groups/users-group-meetings/ph-jug-11sep24.html ...