cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-415994%22%20slang%3D%22de-DE%22%20mode%3D%22UPDATE%22%3E%E3%83%AB%E3%83%BC%E3%83%97%E5%86%85%E3%81%AE%E5%BC%8F%E3%81%A8%E3%81%97%E3%81%A6%E3%81%AE%E5%88%97%E5%90%8D%E3%81%AF%E6%A9%9F%E8%83%BD%E3%81%97%E3%81%BE%E3%81%9B%E3%82%93%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-415994%22%20slang%3D%22de-DE%22%20mode%3D%22UPDATE%22%3E%3CP%3E%E3%81%93%E3%82%93%E3%81%AB%E3%81%A1%E3%81%AF%E3%80%81%E3%82%B3%E3%83%9F%E3%83%A5%E3%83%8B%E3%83%86%E3%82%A3%E3%81%AE%E7%9A%86%E3%81%95%E3%82%93%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E3%82%B0%E3%83%A9%E3%83%95%E3%81%AE%E3%81%84%E3%81%8F%E3%81%A4%E3%81%8B%E3%81%AE%E5%88%97%E3%82%92%E3%83%AB%E3%83%BC%E3%83%97%E3%81%97%E3%81%A6%E3%80%81%E3%81%84%E3%81%8F%E3%81%A4%E3%81%8B%E3%81%AE%E3%82%B0%E3%83%A9%E3%83%95%E3%81%AE%E7%94%9F%E6%88%90%E3%82%92%E8%87%AA%E5%8B%95%E5%8C%96%E3%81%97%E3%82%88%E3%81%86%E3%81%A8%E3%81%97%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E3%81%9F%E3%81%A8%E3%81%88%E3%81%B0%E3%80%81%E7%A7%81%E3%81%AE%E5%88%97%E3%81%AE%E5%90%8D%E5%89%8D%E3%81%AF%E3%80%81H_1%E3%80%81H_2%E3%80%81...%20H_12%20%E3%81%A7%E3%81%99%E3%80%82%3C%2FP%3E%0A%3CP%3E%E7%A7%81%E3%81%AF%E8%A9%A6%E3%81%97%E3%81%9F%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Ex1_%20%3D%20Expr(%20Y(%20Expr(%20%22%3AH_%22%20%7C%7C%20Char(%20iAus%20)%20)%20)%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E7%A7%81%E3%82%82%E8%A9%A6%E3%81%97%E3%81%A6%E3%81%BF%E3%81%BE%E3%81%97%E3%81%9F%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Ex1_%20%3D%20Expr(%20Y(%20Column(%20Expr(%20%22H_%22%20%7C%7C%20Char(%20iAus%20)%20)%20)%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E3%81%9D%E3%81%97%E3%81%A6%E3%81%BE%E3%81%9F%3A%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Ex1_%20%3D%20Expr(%20Y(%20As%20Column(%20Expr(%20%22H_%22%20%7C%7C%20Char(%20iAus%20)%20)%20)%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E3%81%9D%E3%81%97%E3%81%A6iAus%E3%83%AB%E3%83%BC%E3%83%97%E5%86%85%E3%81%A7%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EVariables(%20X(%20%3ATag%20)%2C%20Eval(%20Eval%20Expr(%20x1_%20)%20)%2C%20Group%20X(%20%3ANAT%20)%20)%2C%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E3%81%86%E3%81%BE%E3%81%8F%E3%81%84%E3%81%8D%E3%81%BE%E3%81%9B%E3%82%93%E3%81%A7%E3%81%97%E3%81%9F%E3%80%82%20--%26gt%3B%20%E3%82%A8%E3%83%A9%E3%83%BC%20%3D%20%E6%8C%87%E5%AE%9A%E3%81%95%E3%82%8C%E3%81%9F%E5%88%97%E3%81%8C%E3%83%87%E3%83%BC%E3%82%BF%20%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%81%AB%E8%A6%8B%E3%81%A4%E3%81%8B%E3%82%8A%E3%81%BE%E3%81%9B%E3%82%93%E3%80%82%20'Eval'%20%E3%81%AE%E3%82%A2%E3%82%AF%E3%82%BB%E3%82%B9%E3%81%BE%E3%81%9F%E3%81%AF%E8%A9%95%E4%BE%A1%E3%81%A7%E3%80%81Eval%2F*%23%23%23*%2F(Eval%20Expr(%20x1_%20))%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E6%AC%A1%E3%81%AE%E3%82%88%E3%81%86%E3%81%AB%E3%80%81%E5%BC%8F%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%99%E3%82%8B%E3%81%AE%E3%81%A7%E3%81%AF%E3%81%AA%E3%81%8F%E3%80%81%E5%88%97%E7%95%AA%E5%8F%B7%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%99%E3%82%8B%E5%BF%85%E8%A6%81%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%97%E3%81%9F%E3%80%82%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EVariables(%20X(%20%3ATag%20)%2C%20Y(%20As%20Column(%2026%20%2B%20iAus%20)%20)%2C%20Group%20X(%20%3ANAT%20)%20)%2C%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E7%A7%81%E3%81%AE%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E3%81%AE%E5%88%A5%E3%81%AE%E9%83%A8%E5%88%86%E3%81%A7%E3%81%AF%E3%80%81%E6%AD%A3%E3%81%97%E3%81%8F%E8%A8%98%E8%BF%B0%E3%81%95%E3%82%8C%E3%81%A6%E3%81%84%E3%81%BE%E3%81%97%E3%81%9F%E3%80%82%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Ex1%20%3D%20Expr(%20%22H_%22%20%7C%7C%20Char(%20iAus%20)%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EiAus%20%E3%83%AB%E3%83%BC%E3%83%97%E5%86%85%E3%81%A7%E3%81%AF%3A%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EDispatch(%0A%7B%7D%2C%0AEval(%20Eval%20Expr(%20x1%20)%20)%2C%0AScaleBox%2C%0A%7BFormat(%20%22Fixed%20Dec%22%2C%2015%2C%201%20)%2C%20Min(%200%20)%2C%20Max(%201.4%20)%2C%20Inc(%200.2%20)%2C%20Minor%20Ticks(%201%20)%2C%20Label%20Row(%20Set%20Font%20Size(%2011%20)%20)%7D%0A)%2C%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E8%AA%B0%E3%81%8B%E7%A7%81%E3%82%92%E5%8A%A9%E3%81%91%E3%81%A6%E3%80%81%E7%A7%81%E3%81%8C%E9%96%93%E9%81%95%E3%81%A3%E3%81%A6%E3%81%84%E3%82%8B%E3%81%A8%E3%81%93%E3%82%8D%E3%82%92%E6%8C%87%E6%91%98%E3%81%97%E3%81%A6%E3%81%8F%E3%82%8C%E3%81%BE%E3%81%9B%E3%82%93%E3%81%8B%3F%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E3%82%88%E3%82%8D%E3%81%97%E3%81%8F%E3%81%8A%E9%A1%98%E3%81%84%E3%81%97%E3%81%BE%E3%81%99%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-415994%22%20slang%3D%22de-DE%22%20mode%3D%22UPDATE%22%3E%3CLINGO-LABEL%3E%E3%83%9E%E3%82%B9%E3%82%AB%E3%82%B9%E3%82%BF%E3%83%9E%E3%82%A4%E3%82%BC%E3%83%BC%E3%82%B7%E3%83%A7%E3%83%B3%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-416075%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E3%83%AB%E3%83%BC%E3%83%97%E5%86%85%E3%81%AE%E5%BC%8F%E3%81%A8%E3%81%97%E3%81%A6%E5%88%97%E5%90%8D%E3%81%8C%E6%A9%9F%E8%83%BD%E3%81%97%E3%81%BE%E3%81%9B%E3%82%93%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-416075%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E6%96%87%E5%AD%97%E5%88%97%E3%82%92%E5%BC%8F%E3%81%AB%E9%80%A3%E7%B5%90%E3%81%99%E3%82%8B%E3%81%93%E3%81%A8%E3%81%AF%E3%81%A7%E3%81%8D%E3%81%BE%E3%81%9B%E3%82%93%E3%80%82%20%E4%BB%A3%E6%9B%BF%E3%81%BE%E3%81%9F%E3%81%AF%E8%A9%95%E4%BE%A1%E6%8C%BF%E5%85%A5%E3%83%A1%E3%82%BD%E3%83%83%E3%83%89%E3%82%92%E8%A9%A6%E3%81%97%E3%81%A6%E3%81%8F%E3%81%A0%E3%81%95%E3%81%84%E3%80%82%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJSL-Cookbook-Archived%2FInsert-one-expression-into-another-using-Eval-Insert-Eval-Expr%2Fm-p%2F48998%23U48998%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-tkb-thread%20lia-fa-icon%20lia-fa-tkb%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3EEval%20Insert%E3%80%81Eval%20Expr%E3%80%81Parse%E3%80%81%E3%81%8A%E3%82%88%E3%81%B3%20Substitute%20%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%A6%E3%80%81%E3%81%82%E3%82%8B%E5%BC%8F%E3%82%92%E5%88%A5%E3%81%AE%E5%BC%8F%E3%81%AB%E6%8C%BF%E5%85%A5%E3%81%97%E3%81%BE%E3%81%99%E3%80%82%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
maswan
Level I

Column name as expression inside loop doesn't work

Hello Community,

 

I am trying to automatize the generation of some graphs making a loop over some columns of my graph.

 

For example, my Column's names are: H_1 , H_2 ... H_12

I tried

x1_ = Expr( Y( Expr( ":H_" || Char( iAus ) ) ) );

 

I also tried

x1_ = Expr( Y( Column( Expr( "H_" || Char( iAus ) ) ) );

 

and also:

x1_ = Expr( Y( As Column( Expr( "H_" || Char( iAus ) ) ) );

 

and inside the iAus loop

 

Variables( X( :Tag ), Eval( Eval Expr( x1_ ) ), Group X( :NAT ) ),

 

didn't work out. --> Error = Specified Column not found in data table. in access or evaluation of 'Eval' , Eval/*###*/(Eval Expr( x1_ ))

 

I needed to use the column number rather than using an expression, like this:

Variables( X( :Tag ), Y( As Column( 26 + iAus ) ), Group X( :NAT ) ),

 

In another part of my script I got it right:

x1 = Expr( "H_" || Char( iAus ) );

and inside the iAus loop:

Dispatch(
{},
Eval( Eval Expr( x1 ) ),
ScaleBox,
{Format( "Fixed Dec", 15, 1 ), Min( 0 ), Max( 1.4 ), Inc( 0.2 ), Minor Ticks( 1 ), Label Row( Set Font Size( 11 ) )}
),

 

Can someone help me and point out what I'm doing wrong?

 

Thank you in advance

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
pauldeen
Level VI

Re: Column name as expression inside loop doesn't work

You cannot concatenate a string to an expression. Try the substitute or eval insert method.

Insert one expression into another using Eval Insert, Eval Expr, Parse, and Substitute 

View solution in original post

1 REPLY 1
pauldeen
Level VI

Re: Column name as expression inside loop doesn't work

You cannot concatenate a string to an expression. Try the substitute or eval insert method.

Insert one expression into another using Eval Insert, Eval Expr, Parse, and Substitute 

Recommended Articles