Try statement with Group Columns

Question

I have a list of columns I want to group but the script fails if any of the columns are absent.  A try statement does not seem to fix the problem.

, :Param_3}));dt = Current Data Table();

Try( dt <<  Group Columns ("TM", {:Param_1, :<CODE class="language-jsl">Param_2

mmarchandFSLR · Accepted Answer

If you want to group all columns present in that list (even if, say, :Param_2 is missing), you could try something like this.

Names Default To Here( 1 );
cols = {:a, :b, :c, :d, :e};
dt << Group Columns( "Some Columns", Filter Each( {v, i}, cols, dt << Has Column( Char( Name Expr( v ) ) ) ) );

SpannerHead · Accepted Answer

Had to tweak this a bit to identify dt.

Names Default To Here( 1 );
dt = Current Data Table();
cols = {:a, :b, :c, :d, :e};
dt << Group Columns( "Some Columns", Filter Each( {v, i}, cols, dt << Has Column( Char( Name Expr( v ) ) ) ) );