Combining data tables if number of opened tables varies

Question

Hello,

I have a script that gets items chosen by the user from a list box. Based on the number of items selected by the user, a number of tables pop up. The number of new data tables is variable and I would like to combine them all into one larger table called Combined Table. I know the concatenate function does this, but I would like to have it scripted to accommodate a user specified number of tables.

From this piece of code, a number of new tables pop up named EachChem, EachChem 2, EachChem 3...ectc. I would like to combine those into a larger table called Combined Table.

For (i = 1, i <= N Items(lt), i++,

dt << Select Where( :chemical == lt[i] );
	    dt << Get selected rows
	    dt << Subset(Output Table("EachChem"), Selected Rows(i));
    );

Alternative, if I could combined the tables within the above for loop, and end up with one large subset table called EachChem, that would be good too.

Any help or pointers is appreciated.

txnelson · Accepted Answer

This should do what you want

theExpr = "Data Table( \!"EachChem\!") << Concatenate(";
For( i = 2, i <= N Items( lt ), i++,
	theExpr = theExpr || " Data Table( \!"EachChem " || Char( i ) || "\!"),"
);
theExpr = theExpr || "Output Table( \!"Combined Table\!" ) );";

Eval( Parse( theExpr ) );