Subscribe Bookmark RSS Feed

using table name as variable

KinKame

Community Trekker

Joined:

Nov 30, 2015

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

2 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

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 ) )

       );

);

Jim
KinKame

Community Trekker

Joined:

Nov 30, 2015

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!