How to format a list of columns?

aliegner1 — Fri, 09 Jun 2023 19:47:44 GMT

I just can't seem to figure out the syntax. I'm trying to set this group of columns to a fixed decimal. I can't figure out how to assign the columns to a variable

colList = column( dt, "MEAN", "STDEV", "MIN", "Q1", "MEDIAN", "Q3", "MAX")
For(i=1,i<=n items(colList), i++,
column(dt, colList[i]) << data type("numeric")<< Format( "Fixed Dec", 12, 3 );
);

Re: How to format a list of columns?

brady_brady — Mon, 24 May 2021 19:57:57 GMT

You're close, you just need the column names to be in a list (see code below.)

Be sure to check out "Standardize Attributes" in the columns menu (or from a right-click on a column header). It will allow you to alter settings for all selected columns en-masse via point-and-click, which may obviate the need to script this, depending on your use case.

Cheers,

Brady

dt = Current Data Table();

colList = {"MEAN", "STDEV", "MIN", "Q1", "MEDIAN", "Q3", "MAX"};

For( i = 1, i <= N Items( colList ), i++,
	Column( dt, colList[i] ) << data type( "numeric" ) << Format( "Fixed Dec", 12, 3 )
);

topic Re: How to format a list of columns? in Discussions

How to format a list of columns?

Re: How to format a list of columns?