Hi Dan! Thanks for your help! OK, so I guess it's possible to loop through the records, but I'm still a bit confused as to how I can compare a certain column-value for all of the records. I need to find out which record has the highest value (a number in the column "sales"), and when I've found it, I want the rule to return the value of another field in that record (company_name).
Could you possibly give me a hint of how to achieve this? Thanks again! /Marie > Yes, you can use the ExternalDataFileEx object to iterate through all of > the records in your flat (delimited) input file. Please refer to the > FusionPro Rules System Guide for more information. > > Dan ----------------------------------------------- I'm working on a product where we would like to print out some text depending on which record in the input file has the highest number. For example - a certain store has the highest number of sold items - which means I have to loop through all the records, compare the number in a certain column (sales), and then I need to print out the company name of the record with the highest value in the "sales"-column. Is this possible to acheive? Thanks in advance for your input or ideas! +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- FusionPro 5.0 Now Available! Variable text on a curve and soft drop-shadows for variable text LIMITED TIME upgrade offer of $299 per license for current customers: http://fusionpro.printable.com/store/upgrade New licenses available for $599 each at: http://fusionpro.printable.com/store/ All FusionPro 5.0 customers to receive FusionPro 5.1 with Adobe Acrobat 8 and InDesign CS3 support when released for FREE. +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- -- Users of FusionPro Desktop have unlimited free email support. Contact Printable Support at [EMAIL PROTECTED] -- View FusionPro Knowledge Base, FusionPro Samples at www.printable.com/vdp/desktop.htm -- You are currently subscribed to fusionpro as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] -- -- Note: All e-mail sent to or from this address will be received or otherwise recorded by the e-mail recipients of this forum. It is subject to archival, monitoring or review by, and/or disclosure to someone other than the recipient. Our privacy policy is posted on www.printplanet.com --
