TD_RoundColumns Column Examples - Analytics Database

You can also input multiple columns in the TargetColumns parameter to have these statistics calculated for all those columns at the same time. If you want stats for all columns, a shorter way to do this would be to add [:] in the TargetColumns parameter.

titanic2: Input Table

The following input table is used for these examples.

Multiple Columns SQL Call

SELECT * FROM TD_RoundColumns (
  ON titanic2 AS InputTable
  USING
  TargetColumns ('fare','height_cms')
  PrecisionDigit (1)
  Accumulate ('[0:1]','survived')
) AS dt;

Multiple Columns Output

All Columns SQL Call

SELECT * FROM TD_RoundColumns (
  ON titanic2 AS InputTable
  USING
  TargetColumns ('[:]')
  PrecisionDigit (1)
) AS dt;

All Columns Output