Column name as expression inside loop doesn't work

maswan — Sun, 11 Jun 2023 11:17:15 GMT

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

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

pauldeen — Tue, 07 Sep 2021 16:54:56 GMT

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

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

Column name as expression inside loop doesn't work

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