Scripting: Retrieving Column certain names of a data table

martindemel

Hi,

I have a data table (imported from Excel) where some column names have a date Format (e.g. September 14). But there are other columns as well. Attached you find the jmp data table Example1. There are two issues.

First Issue:

I need to stack the date columns to have them e.g. as X in a Graph Builder analysis.This is not very difficult (script in Example1, but the table will be a living document and new columns will be added as months progress and therefore I cannot use the automated script with hard coded columns.

I need to extract those column names with such a date structure (Month YY) and stack them. I tried to use Get Column Name which extracts the column list:

colNames = Data Table( "Example1" ) << Get Column Names;

show(colNames);

But I could not extract just the ones I'm interested to stack. I thought about Regex() but couldn't get it run in the way I liked it to have.

Second Issue:

Then the next issue appears. The data type will be character and nominal. I would like it to be numeric and ordinal (or at least character and ordinal but in the correct series). When changing the property to numeric I got a lot of missing values, but not all.

Not sure what I do wrong here.

Thanks for your help,

Martin

Example1automation.jsl

Example1.jmp

DonMcCormack

Martin,

I'm attaching a script that should solve the issues you're having. Regex is particularly tricky to use in JSL and varies somewhat from standard regular expressions (although, it's pretty close, mostly missing some functionality). The date issues are occurring because JMP did not recognize the dates as an available informat, at least I didn't see them on my version. My solution parsed the name and created a new column with numeric dates. There are alternative solutions, although I though this would be the easiest. !

Example1automation (DWMc edits).jsl