cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
trisampson
Level I

JSL Script - How to extract a table cell value and save to variable

Hi all,

I have a script that opens up several temporary data tables (csv files) and then saves my analysis to a journal window. I would like to save the journal to an HTML file, but I need to save the filename with a value from one of the data tables. I'm not sure how to save a table value to a variable:

NewWindow("PartJournal",<PartData = Open ("C:\...path...\filename.csv");
row()=1;
filename=Column("Customer");
... other tables opened and results saved to journal ...
filepath = "C:\...path...\" || filename || ".html";
Current Journal() << Save HTML(char(filepath));

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Duane_Hayes
Staff (Retired)

Re: JSL Script - How to extract a table cell value and save to variable

As stated above:

 

 

Hey, the syntax I use to get a value out of a table is this:

rowNum = 1;
col = Column( Current Data Table(), columnName);
tableVal = col[ rowNum ];

Hope this helps!

Duane Hayes

View solution in original post

2 REPLIES 2

Re: JSL Script - How to extract a table cell value and save to variable

Hey, the syntax I use to get a value out of a table is this:

rowNum = 1;
col = Column( Current Data Table(), columnName);
tableVal = col[ rowNum ];

Hope this helps!

Duane_Hayes
Staff (Retired)

Re: JSL Script - How to extract a table cell value and save to variable

As stated above:

 

 

Hey, the syntax I use to get a value out of a table is this:

rowNum = 1;
col = Column( Current Data Table(), columnName);
tableVal = col[ rowNum ];

Hope this helps!

Duane Hayes