18 July 2018
Register today

Trace Financial adds Excel capabilities to Transformer

09 September 2013  |  1371 views  |  0 Source: Trace Financial

Trace Financial has released version 3.4 of Transformer, the company's advanced message transformation application.

Transformer now offers powerful facilities for working with Microsoft Excel workbooks, allowing financial messages to be created from, or transformed into, spreadsheet data.

Users can automatically create Transformer message definitions from an Excel workbook using its column heading labels and cell data types. Transformer can also incorporate worksheet-level headings and trailers in this message definition. The runtime Transformer is then able to read workbooks and transform the data into, for example, a SWIFT Statement message with multiple posting lines. Similarly the target output from a transformation can also now be a spreadsheet. A new family of mapping actions has been developed, allowing the user to access and control the properties of workbooks, sheets, and individual cells.

Release 3.4 also extends Transformer's powerful Design Time GUI with a new set of screens allowing users to easily define and maintain predicate logic. This logic is used to select from among repeating data components, for example to find in a set of parties the one with a certain role, or the first one which has an address. This can be especially useful when working with advanced FpML messages, which often use complex repeating components.

The release contains many other enhancements to existing Transformer features and also includes the ability to deploy mappings as RESTful web services.
John Murphy, Managing Director of Trace Financial, said: "Each Transformer release gives our clients even more powerful tools to help them work effectively with complex financial messages. Transformer's ability to both create and read spreadsheets has already proved its worth in recent client projects."

Comments: (0)

Comment on this story (membership required)

Related company news


Related blogs

Create a blog about this story (membership required)
Visit info.nice.comVisit http://go.jumio.com/finextraAdVisit https://secure.vasco.com

Top topics

Most viewed Most shared
Metro Bank opens developer portalMetro Bank opens developer portal
9518 views comments | 5 tweets | 14 linkedin
Anything Visa can do...Mastercard takes time outAnything Visa can do...Mastercard takes ti...
8910 views comments | 6 tweets | 14 linkedin
Citi to streamline corporate receivables with HighRadiusCiti to streamline corporate receivables w...
7851 views comments | 1 tweets | 5 linkedin
Mastercard enlists Worldpay to push Vocalink's Pay by Bank appMastercard enlists Worldpay to push Vocali...
7790 views 19 comments | 14 tweets | 29 linkedin
Banks stand to reap $512 billion revenue boost from 'intelligent automation'Banks stand to reap $512 billion revenue b...
7661 views comments | 21 tweets | 30 linkedin

Featured job

Competitive base, double ote, benefits
New York City, NY - USA

Find your next job