How to obtain unique attribute tables with numbers?

Table-valued functions in finaquant .net libraries

How to obtain unique attribute tables with numbers?

Postby dinara » 24 Jun 2014, 19:08

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?
dinara
 
Posts: 3
Joined: 16 Nov 2013, 11:16

Re: How to obtain unique attribute tables with numbers?

Postby tunc » 22 Jul 2014, 19:46

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
tunc
 
Posts: 25
Joined: 22 Jul 2014, 19:29
Location: Switzerland


Return to Table Functions

Who is online

Users browsing this forum: No registered users and 1 guest

cron