How to use columnlist to stack a lot of columns

engr

Hi all, I want to read out the column names and save them as a column list .... using this list can I stack these multiple columns in a single command instead of manual stacking like the code shown below ?

dt_L5 << Stack(

    columns(

        :Name( "MISC_L5_Test230_2(1)" ),

        :Name( "MISC_L5_Test230_2(2)" ),

        :Name( "MISC_L5_Test230_2(3)" ),

        :Name( "MISC_L5_Test230_2(4)" ),

        :Name( "MISC_L5_Test230_2(5)" ),

        :Name( "MISC_L5_Test230_2(6)" ),

        :Name( "MISC_L5_Test230_2(7)" ),

        :Name( "MISC_L5_Test230_2(8)" ),

          .

          .

          .

          .

       :Name( "MISC_L5_Test230_2(125)" )

),

    Source Label Column( "Label" ),

    Stacked Data Column( "Data" ),

    Output Table( "L5" )

);

I want to do some thing like this :

clist=dt_L5<<Get Column Names;

ncols = N Items(clist);

dt_L5 << Stack(

    columns(

     for(i=1,i<=ncols,i++,

         name_list = clist;

         /* HOW SHOULD I CALL THE ":Name("name_list") " here ?? */

     );

    Source Label Column( "Label" ),

    Stacked Data Column( "Data" ),

    Output Table( "L5" )

);

ms

Either contitionally like this:

tlist={};

for(i=1,i<=ncols,i++,

    if(i>3,

        insertinto(tlist,collist[i]);

    );

);

or without condition but a modified initial i:

tlist={};

for(i=4,i<=ncols,i++,

        insertinto(tlist,collist[i]);

);