Summarization dynamically

[kpmINFO]

Hi,

I have to do a summarization in mapping where i get these are source columns Sr1 to Sr5

Sr1 Sr2 Sr3 Sr4 Sr5
1.1 2.1 12 14 30
1.1 2.1 13 19 40
1.2 2.2 10 9 20
1.2 2.2 12 42 10
1.2 2.2 13 34 50
1.3 2.3 3 2 60
1.3 2.3 4 8 20
1.4 2.4 3 6 50
1.5 2.5 4 8 90


I need the Target Output as t1-t5 target columns
(BRACKETS ARE ONLY FOR YOUR UNDERSTANDING ONLY) I only need Values.

ALso one more thing i am looking at is can i do it dynamically say i know specifically that group by sr1 and sr2 , If somebody gives me tobesummarized columns in database table as sr1 and sr3 . can i grab that information and compute the summarization.I know using aggregator we can do group by on sr1,sr2 by checking that options. But without checking this options in aggregator can i do it.

t1 t2 sumation Recordcount
1.1 2.1 70(30+40) 2
1.2 2.2 80(20+10+50) 3
1.3 2.3 80(60+20) 2
1.4 2.4 50 1
1.5 2.5 90 1
Thanks
KPM

 

[blom0344]

AFAIK you cannot make this dynamical the way you expect this, but you could create a number of views (exchanging column-order in the view)on the source and then load the view based on which columns you want to aggregate.

You can simply override the source in the session manager to change the columns you want to aggregate....

T. Blom
Information analyst
tbl@shimano-eu.com