cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
%3CLINGO-SUB%20id%3D%22lingo-sub-780140%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%EC%95%A1%EC%84%B8%EC%8A%A4%20For%20%EB%A3%A8%ED%94%84%EC%97%90%EC%84%9C%20%ED%85%8C%EC%9D%B4%EB%B8%94%20%EC%9D%B8%EC%88%98%EB%A1%9C%20%EC%9D%B8%EC%8B%9D%EB%90%98%EC%A7%80%20%EC%95%8A%EC%9D%8C%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-780140%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3E%ED%95%98%EC%9C%84%20%EC%A7%91%ED%95%A9%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%9D%84%20%EC%97%B0%EA%B2%B0%ED%95%98%EB%A0%A4%EA%B3%A0%20%ED%96%88%EC%A7%80%EB%A7%8C%20%EA%B3%84%EC%86%8D%20%EB%8B%A4%EC%9D%8C%20%EC%98%A4%EB%A5%98%EA%B0%80%20%EB%B0%9C%EC%83%9D%ED%96%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3CBR%20%2F%3E%20'dtSubsetList%20%5B%20%2F*%23%23%23*%2Fi%5D'%20%2C%20dtSubsetList%20%5B%2F*%23%23%23*%2Fi%5D%EC%9D%98%20%EC%95%A1%EC%84%B8%EC%8A%A4%20%EB%98%90%EB%8A%94%20%ED%8F%89%EA%B0%80%EC%97%90%EC%84%9C%20%ED%85%8C%EC%9D%B4%EB%B8%94%20%EC%9D%B8%EC%88%98%EB%A1%9C%20%EC%9D%B8%EC%8B%9D%EB%90%98%EC%A7%80%20%EC%95%8A%EC%9D%8C%3C%2FP%3E%3CP%3EIm%20using%20JMP%2016%3CCODE%20class%3D%22%20language-jsl%22%3E%3C%2FCODE%3E%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3Enames%20default%20to%20here(1)%3B%0Adt%20%3D%20Open(%20%22%24SAMPLE_DATA%2FBig%20Class.jmp%22%20)%3B%0A%0AdtSubsetList%20%3D%20dt%20%26lt%3B%26lt%3B%20Subset(%0A%09By(%20%3Asex%20)%2C%0A%09All%20rows%2C%0A%09Selected%20columns%20only(%200%20)%2C%0A%09columns(%20%3Aname%2C%20%3Aage%2C%20%3Aheight%2C%20%3Aweight%20)%0A)%3B%0A%0AdtNew%20%3D%20New%20Table(%20%22New%20Table%22%20)%3B%0A%20%0AFor(i%20%3D%201%2C%20i%20%26lt%3B%3D%20N%20Items(dtSubsetList%20)%2C%20i%2B%2B%2C%20%0AdtNew%20%26lt%3B%26lt%3B%20Concatenate(dtSubsetList%5Bi%5D%2C%20Append%20to%20first%20table(1))%3B%20%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-780140%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CLINGO-LABEL%3E%EC%9E%90%EB%8F%99%ED%99%94%20%EB%B0%8F%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8C%85%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%EC%9C%88%EB%8F%84%EC%9A%B0%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-780152%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%EC%95%A1%EC%84%B8%EC%8A%A4%20For%20%EB%A3%A8%ED%94%84%EC%97%90%EC%84%9C%20%ED%85%8C%EC%9D%B4%EB%B8%94%20%EC%9D%B8%EC%88%98%EB%A1%9C%20%EC%9D%B8%EC%8B%9D%EB%90%98%EC%A7%80%20%EC%95%8A%EC%9D%8C%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-780152%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%EB%AC%B8%EC%A0%9C%EB%A5%BC%20%EC%9E%AC%ED%98%84%ED%95%A0%20%EC%88%98%20%EC%97%86%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EA%B0%80%20%EC%98%A4%EB%A5%98%20%EC%97%86%EC%9D%B4%20%EC%A0%9C%EB%8C%80%EB%A1%9C%20%EC%8B%A4%ED%96%89%EB%90%A9%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CP%3EJMP%EB%A5%BC%20%EC%A2%85%EB%A3%8C%ED%95%9C%20%EB%8B%A4%EC%9D%8C%20%EB%8B%A4%EC%8B%9C%20%EC%97%B4%EC%96%B4%EC%84%9C%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EB%A5%BC%20%EC%8B%A4%ED%96%89%ED%95%98%EB%8A%94%20%EA%B2%83%EC%9D%B4%20%EC%A2%8B%EC%8A%B5%EB%8B%88%EB%8B%A4.%20dt_Test%EB%8A%94%20%EB%B6%84%EB%AA%85%ED%9E%88%20%EC%A0%9C%EA%B3%B5%ED%95%9C%20JSL%EC%97%90%20%EC%97%86%EC%9C%BC%EB%A9%B0%2C%20%EC%95%84%EB%A7%88%EB%8F%84%20%EC%8B%9C%EB%8F%84%ED%95%9C%20%EB%AA%A8%EB%93%A0%20%EC%8B%9C%ED%96%89%EC%B0%A9%EC%98%A4%EC%9D%98%20%EC%95%84%ED%8B%B0%ED%8C%A9%ED%8A%B8%EC%9D%BC%20%EA%B2%83%EC%9E%85%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CP%3E%EB%98%90%ED%95%9C%20%EC%BD%94%EB%93%9C%20%EB%B3%80%EA%B2%BD%EC%9D%84%20%EC%A0%9C%EC%95%88%ED%95%98%EA%B2%A0%EC%8A%B5%EB%8B%88%EB%8B%A4.%20Concatenate%20%ED%94%8C%EB%9E%AB%ED%8F%BC%EC%9D%80%20%EB%8B%A8%EC%9D%BC%20%EC%8B%A4%ED%96%89%EC%97%90%EC%84%9C%20%EC%97%AC%EB%9F%AC%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%9D%84%20%EC%97%B0%EA%B2%B0%ED%95%A0%20%EC%88%98%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EB%94%B0%EB%9D%BC%EC%84%9C%20%EA%B0%81%EA%B0%81%EC%9D%84%20%EA%B0%9C%EB%B3%84%EC%A0%81%EC%9C%BC%EB%A1%9C%20%EB%B0%98%EB%B3%B5%ED%95%A0%20%ED%95%84%EC%9A%94%20%EC%97%86%EC%9D%B4%20Concatenation%EC%97%90%20%EC%A0%84%EC%B2%B4%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%20%EB%AA%A9%EB%A1%9D%EC%9D%84%20%EC%8B%A4%EC%A0%9C%EB%A1%9C%20%EC%A0%84%EB%8B%AC%ED%95%A0%20%EC%88%98%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0Adt%20%3D%20Open(%20%22%24SAMPLE_DATA%2FBig%20Class.jmp%22%20)%3B%0A%0AdtSubsetList%20%3D%20dt%20%26lt%3B%26lt%3B%20Subset(%0A%09By(%20%3Asex%20)%2C%0A%09All%20rows%2C%0A%09Selected%20columns%20only(%200%20)%2C%0A%09columns(%20%3Aname%2C%20%3Aage%2C%20%3Aheight%2C%20%3Aweight%20)%0A)%3B%0A%0AdtNew%20%3D%20New%20Table(%20%22New%20Table%22%20)%3B%0A%20%0A%2F*For(%20i%20%3D%201%2C%20i%20%26lt%3B%3D%20N%20Items(%20dtSubsetList%20)%2C%20i%2B%2B%2C%0A%09dtNew%20%26lt%3B%26lt%3B%20Concatenate(%20dtSubsetList%5Bi%5D%2C%20Append%20to%20first%20table(%201%20)%20)%0A)%3B*%2F%0A%0AdtNew%20%26lt%3B%26lt%3B%20Concatenate(%20dtSubsetList%2C%20Append%20to%20first%20table(%201%20)%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
UserID16644
Level V

unrecognized as table argument in access For loop

I am trying to concatenate my subset tables, but I kept getting this error:
unrecognized as table argument in access or evaluation of 'dtSubsetList [ /*###*/i]' , dtSubsetList [/*###*/i]

Im using JMP 16

 

names default to here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

dtSubsetList = dt << Subset(
	By( :sex ),
	All rows,
	Selected columns only( 0 ),
	columns( :name, :age, :height, :weight )
);

dtNew = New Table( "New Table" );
 
For(i = 1, i <= N Items(dtSubsetList ), i++, 
dtNew << Concatenate(dtSubsetList[i], Append to first table(1)); 
);

 

 

1 REPLY 1
txnelson
Super User

Re: unrecognized as table argument in access For loop

I am unable to replicate the issue.  Your script runs properly without error.

I suggest that you exit JMP, and then reopen it and then run the script.  Your dt_Test is obviously not in the JSL you provided, and is probably an artifact of all of the trial and errors you have attempted.

I will also suggest a change to your code.  The Concatenate platform has the ability to concatenate more than one table in a single execution.  Therefore you can actually past the complete list of data table to the Concatenation rather than having to loop through each one separatly.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

dtSubsetList = dt << Subset(
	By( :sex ),
	All rows,
	Selected columns only( 0 ),
	columns( :name, :age, :height, :weight )
);

dtNew = New Table( "New Table" );
 
/*For( i = 1, i <= N Items( dtSubsetList ), i++,
	dtNew << Concatenate( dtSubsetList[i], Append to first table( 1 ) )
);*/

dtNew << Concatenate( dtSubsetList, Append to first table( 1 ) );
Jim