topic Reference Subset Data Tables Created from a Loop in Discussions

Reference Subset Data Tables Created from a Loop

jgrosjean — Sat, 15 Jul 2017 10:52:11 GMT

I'm having some issues referencing subset data tables made from a loop. The loop works fine and creates data tables named cond1, cond2, etc, but if I try to reference those newly created tables in later code, the script log says it can't find them. Oddly enough if I run my script peicewise, it works just fine.

for(i=1, i<=10, i++,
Original_table << select where(:Sorting Condition == i);

dti = Original_table << Subset(
Output table("cond"||char(i)),
Selected Rows( 1 ),
Selected columns only( 0 )
);
);

datatable("cond"||char(i)) << new column("random", numeric, continuous, formula(round(Random Uniform(1,150)),0));

Re: Reference Subset Data Tables Created from a Loop

Mark_Bailey — Sat, 15 Jul 2017 11:13:50 GMT

It might be simpler to insert the new data table reference dt into a list and then you can subscript or stream over the list when you need to work with a particular data table.

open tables = List();

For( i = 1, i <= 10, i++,
	Original_table << select where( :Sorting Condition == i );
	dti = Original_table << Subset(
		Output table( "cond" || Char( i ) ),
		Selected Rows( 1 ),
		Selected columns only( 0 )
	);
	Insert Into( open tables, dti );
);

open tables[i] << New Column( "random",
	numeric,
	continuous,
	formula( Round( Random Uniform( 1, 150 ) ), 0 )
);

Re: Reference Subset Data Tables Created from a Loop

jgrosjean — Sat, 15 Jul 2017 12:32:55 GMT

That works great! Thanks!