Page 1 of 1

How to obtain unique attribute tables with numbers?

PostPosted: 24 Jun 2014, 19:08
by dinara
Hello,

the table function MatrixTable.UniqueAttributeRows returns a table with unique combinations of attribute values, without key figures.

How can I obtain unique attributes table with numbers?

Re: How to obtain unique attribute tables with numbers?

PostPosted: 22 Jul 2014, 19:46
by tunc
Hello Dinara,

In order to obtain a data table with unique attribute combinations (of type MatrixTable) you need to aggregate key figure fields with an aggregation function like sum, average, min or max.

You can use use the aggregation functions of Table Function libraries finaquant protos or calcs, like:
Code: [Select all] [Expand/Collapse] [Download] (Untitled.txt)
  1. MatrixTable.AggregateAllKeyFigures()
  2. MatrixTable.AggregateSelectedKeyFigure_A()
  3. MatrixTable.AggregateAllKeyFigures_UserFunc()
GeSHi ©


You may find aggregation examples in the downloadable Visual Studio projects FinaquantCalcsStarter or FinaquantProtosStarter. See demo function:
Code: [Select all] [Expand/Collapse] [Download] (Untitled.txt)
  1. DemoFunctions.Table_aggregation_functions()
GeSHi ©


Tunc