topic Re: column reference plot of graph builder in Discussions

column reference plot of graph builder

vishwasanj — Sun, 15 Oct 2017 13:34:51 GMT

Thank you for giving amazing suggestions.

I encountered something else and I have always been curious about this. Whenever I come across this, I try to stack to circumvent the problem.

In a graph builder, how to plot without knowing the name of the column

collist =fudt<< get column names(string);
qdt=Char(collist[9]); //Assuming I want to plot column number 9 on the Y axis, say for example "Data_ABC"
 
gbfc = fudt<<Graph Builder(
Size( 1899, 922 ),
Show Control Panel( 0 ),
Variables(
X( :Index ),
X( :Lot, Position( 1 ) ),
X( :Wafers, Position( 1 ) ),
Y( :qdt),// THIS DOESN't WORK - I want to understand the syntax
Color( :temp )
)
Elements( Points( X( 1 ), X( 2 ), X( 3 ), Y, Legend( 33 ) ) )
);

Thank you.

Re: column reference plot of graph builder

uday_guntupalli — Sun, 15 Oct 2017 13:43:51 GMT

@vishwasanj:

dt = Current Data Table();
cdlg = Column Dialog( clist = ColList( "Pick 2 Columns", Min Col( 2 ), Max Col( 2 ) ) );
cols = cdlg["clist"];
 
newColExpr = Expr( dt << New Column( "Radius", Numeric, Formula( Sqrt( Expr( cols[1] ) ^ 2 + Expr( cols[2]; ) ^ 2 ) ) ) );
 
Eval( Eval Expr( newColExpr ) );

https://community.jmp.com/t5/Discussions/JSL-Creating-formula-using-a-variable-column-name/td-p/942/page/2

Re: column reference plot of graph builder

vishwasanj — Tue, 10 Oct 2017 22:28:45 GMT

That was cool. Thank you Uday.

Re: column reference plot of graph builder

pmroz — Wed, 11 Oct 2017 12:50:28 GMT

Your variable qdt points to the name of the column. It is not a column itself. You have to reference it using the construct column(fudt, qdt):

gbfc = fudt << Graph Builder(
	Size( 1899, 922 ),
	Show Control Panel( 0 ),
	Variables(
		X( :Index ),
		X( :Lot, Position( 1 ) ),
		X( :Wafers, Position( 1 ) ),
		Y( Column( fudt, qdt ) ), 	// use column pointed to by the qdt variable
		//Y( :qdt),	// THIS DOESN't WORK - I want to understand the syntax
		Color( :temp ),

	),
	Elements( Points( X( 1 ), X( 2 ), X( 3 ), Y, Legend( 33 ) ) )
);

Re: column reference plot of graph builder

vishwasanj — Wed, 11 Oct 2017 19:09:14 GMT

Interesting. Let me try that syntax. Thank you pmroz

Re: column reference plot of graph builder

GoodMan — Sun, 15 Oct 2017 02:36:56 GMT

Uday,

Thanks for your post. Here i can see the fomula code as follows. Can you explan what means cols[1&#93 and cols[2&#93?

Formula( Sqrt( Expr( cols[1] ) ^ 2 + Expr( cols[2] ) ^ 2 ) )

Re: column reference plot of graph builder

uday_guntupalli — Sun, 15 Oct 2017 04:17:22 GMT

@GoodMan,
Thanks for pointing out . I recollected and recalled that from the post . Not the way I would do it .

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
ColNames = dt << Get Column Names("String"); 

Stmt = "";
Stmt = ":" || ColNames[2] || "*2";
					   
Eval( Parse( Eval Insert("\[ dt << New Column("Age_Squared",Numeric,Continuous,Formula(^Stmt^)); ]\" ) ) );

Re: column reference plot of graph builder

GoodMan — Sun, 15 Oct 2017 13:45:36 GMT

Thanks. Following your new code, go back the the previous example, still i have some problem. Can you help me?

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
cdlg = Column Dialog( clist = ColList( "Pick 2 Columns", Min Col( 2 ), Max Col( 2 ) ) );
cols = cdlg["clist"];
newColExpr = Expr( dt << New Column( "Radius", Numeric, Formula( Sqrt( Expr( cols ) ^ 2 + Expr( cols) ^ 2 ) ) ) );
Eval( Eval Expr( newColExpr ) );

Re: column reference plot of graph builder

GoodMan — Sun, 15 Oct 2017 06:53:01 GMT

Uday,
I checked your previous code again. Now i understand that &#91=[. So now I can figure it out now. Thank you anyway!
GM

Re: column reference plot of graph builder

Jeff_Perkinson — Sun, 15 Oct 2017 13:44:49 GMT

Those were meant to be square brackets. I've edited the post and corrected that.