aggregation in data services

dataservices metadata reports
1

Hi,

I am very new to data services, so please bear with if the question is too simple .
I have a table in data services where it has 4 columns. And i need to sum up the column 4 if first 3 columns are same. any simple explanation on how to achieve this would be great.

ram79 (BOB member since 2014-11-13)

2

This is probably a Group By. In the Query transform of a Dataflow you would add the first three columns to the Group By list and then in the mapping for the fourth column use the sum() function.

eganjp :us: (BOB member since 2007-09-12)