topic Re: Insert values from a table into a list then use list to select rows from another table in Discussions

Insert values from a table into a list then use list to select rows from another table

nrodrig1 — Mon, 12 Aug 2019 12:56:39 GMT

Hi,

I want to select valeus from one table to select values in another table. I'm doing this by trying to put all the row valeus into a list. Then use that list to select where. I'm hung up on the part where i'm putting the row values into my list.

Any help would be great:

UnqDscrptns << set name( "UnqDscrptns" );

MyList_1 = {};

For( i = 1, i <= N Rows( UnqDscrptns ), i++,
	Insert Into( MyList_1, Column( 1 ) )
);

There's more code but my work computer that has JMP isnt' letting me signon to JMP community.

Re: Insert values from a table into a list then use list to select rows from another table

Mark_Bailey — Sat, 10 Aug 2019 15:35:47 GMT

Try this:

MyList_1 = Column( 1 ) << Get Values;

Re: Insert values from a table into a list then use list to select rows from another table

nrodrig1 — Sat, 10 Aug 2019 16:59:31 GMT

Thanks you! This is very close. but i have two tables and it seems to make
the list from the table I don't want. There are two tables open I want to
get it from the table called "UnqDscrptns". I tried a few things like:
MyList_1=datatable("UnqDscrptns").column(1)<< Get values;
and
MyList_1=datatable("UnqDscrptns",column(1))<< Get values;

Re: Insert values from a table into a list then use list to select rows from another table

Mark_Bailey — Sat, 10 Aug 2019 17:20:34 GMT

I have no idea where you are getting this syntax from but it is wrong. It seems like you are trying random syntax or syntax from another computer language. I suggest that you see Help > Books > Scripting Guide for a background in JSL syntax.

Try this:

MyList_1 = Column( Data Table( "UnqDscrptns" ), 1 ) << Get Values;

Re: Insert values from a table into a list then use list to select rows from another table

nrodrig1 — Sat, 10 Aug 2019 18:03:19 GMT

Thank youuu!
yes, i was trying random syntax... i apologize i was getting frustrated with my work computer and probably didn't spend enough time in the scripting guide.