Combining XML Data Together From Multiple Files

Post Reply
GSBSwitch1
Member
Posts: 25
Joined: Thu Jan 07, 2016 8:42 pm

Combining XML Data Together From Multiple Files

Post by GSBSwitch1 »

Is it possible to run a calculation to add a particular number found within the XML data of multiple PDFs. I have a grouping of PDFs with XML data coming into the flow (each instance of this would have a different number of PDFs), and there is a number that I'd like to extract and combine from each file. So lets says there are 5 PDFs and they each have the number 10 extracted from a string in each of their XML data, how would I go about adding 10+10+10+10+10 to extrapolate that this group of PDFs has a combined figure of 50?

If anybody has any ideas I'd really appreciate your feedback. I keep hitting a wall in my brainstorming on this.
loicaigon
Advanced member
Posts: 362
Joined: Wed Jul 10, 2013 10:22 am

Re: Combining XML Data Together From Multiple Files

Post by loicaigon »

Maybe feasable with a lot of trickery with rename element (meaning porting quantity to prefix) then compute all the prefixes but eventually it may be more pertinent to use a script.
Post Reply