BizTalk Server General - Summarize the Amount based on a key field

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server General > November 2004 > Summarize the Amount based on a key field





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Summarize the Amount based on a key field
Ragav

2004-11-21, 2:46 am

Thanks Nabeel.
I do access the newsgroup through the URL:
http://communities.microsoft.com/Ne...ps/default.asp?
ICP=BizTalk&sLCID=US&NewsGroup=microsoft.public.biztalk.ge
neral&iPageNumber=1

I do not find any attachement feature in that. If you can
give me your email, i could send it to you. My email id:
abcRagav@abcIndiatimes.abccom
Remove all the instances of abc from the above email id.

Thanks.
>-----Original Message-----
>Summarize the Amount based on a key field.
>
>I have input record(s) and transforming into target

record
>(s). But I need to SUM by group and values has to go to
>respective records.
>
>Source:
>Key field Amount others
>A 10 x
>A 20 y
>
>Target:
>Key Field Amount Total others
>A 10 30 x
>A 20 30 y
>B 30 70 p
>B 40 70 q
>
>The built in Cumulative Sum functoid sums up the values
>from all the records.
>
>Thanks in advance.
>.
>

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com