- This topic has 1 reply, 1 voice, and was last updated 8 years, 4 months ago by
.
-
Posts
-
-
Hello all,
somewhat new to BT 2006, so here goes!We process XML files throughout the day, and each XML file contains several hundred orders. I'd like to be able to total certain values from each order so that for each XML file I can show that there were x orders, x amount of this product, x amount of that product, and a total dollar value of x. We can then ensure that the system importing the orders processed what we think it did. Is this massively horrible or is there a good way to do this?
Thanks in advance,
Henry
-
You can use BAM. This will allow you to report on what is happening from the aggregated data – this will not be much use as a validity check in the Orders system and will probably duplicate reports from the Order system.
You can total values in a map. You can use the RecordCount functoid to count the number of orders per file and the CumulativeSum functoid for the total orders value. To sum product quantities or amounts will probably require some custom Xslt in a map as you will need to group products by SKU .
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.