cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Learn some foundational elements of JMP Scripting Language (JSL) and how to extend point & click automation into repeatable, shareable routines. Register. June 26, 2 p.m. US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
HSS
HSS
Level IV

How to parse a formula / comparison from a column and apply on other column

Hi All,
I need to apply formula "Expected values" on my "Results[in%Format]" and store the Yes(1) or No (0) in my results column. I have tried different version of Eval()  and Parse() with no success.

Any help please.

 

HSS_0-1674330936955.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: How to parse a formula / comparison from a column and apply on other column

First build a string and then use Eval(Parse())

Eval(Parse(Char(:"Results[in%Format]"n) || :Expected Values))

jthi_0-1674332472261.png

 

-Jarmo

View solution in original post

2 REPLIES 2
jthi
Super User

Re: How to parse a formula / comparison from a column and apply on other column

First build a string and then use Eval(Parse())

Eval(Parse(Char(:"Results[in%Format]"n) || :Expected Values))

jthi_0-1674332472261.png

 

-Jarmo
HSS
HSS
Level IV

Re: How to parse a formula / comparison from a column and apply on other column

Yes it worked. Thanks Jarmo

Recommended Articles