topic Re: using table name as variable in Discussions

using table name as variable

KinKame — Wed, 13 Jul 2016 06:42:47 GMT

hello

I would like to rename 3 tables and I tried to use a for loop as below, but without results so far.

Does anyone get any idea?

tb_list = {"SPC_tb", "SPEC_tb", "Data_tb"};

dtt = Data Table(tb_list[1]) << Get Selected;

For( k = 1, k < 4, k++,

dtt = Data Table( eval(tb_list) << Get Selected[1] );

name_list = dtt << get column names();

column_name_tb = New Table( "xx_temp_name_table" );

column_name_tb << New Column( "name", Character, Set Values( name_list ) );

column_name_tb << New Column( "rename", formula( "rule" || :name ) );

rename_list = Column( column_name_tb, "rename" ) << getValues;

For( i = 1, i < N Col(dtt) + 1, i++,

Eval( Column( dtt, i ) << set name( rename_list ) )

)

);

Lionel

Re: using table name as variable

txnelson — Wed, 13 Jul 2016 11:22:33 GMT

I am not absolutely sure as to what you are attempting to do, however, if what I am detecting is the purpose of your code is to rename the columns in 3 data table, here is a piece of code that will do it:

Names Default To Here( 1 );

tb_list = {"SPC_tb", "SPEC_tb", "Data_tb"};

For( k = 1, k <= 3, k++,

dtt = Data Table( tb_list );

For( i = 1, i < N Col( dtt ), i++,

Column( dtt, i ) << set name( "rule" || Char( Column( dtt, i ) << get name ) )

);

Re: using table name as variable

KinKame — Wed, 13 Jul 2016 14:28:54 GMT

works nicely. Good detection :)

my mistake was to input in the list not the table name but the object associated.

SPC_tb = data table("SPC").

thank you!