Category: Transformer

Summarize CSV – Columns to context – BMECAT

Problem: Several columns of CSV data shall be summarized to one XML node. CSV example data: MERKMAL_NAME1;MERKMAL_UNIT1;MERKMAL_VALUE1;MERKMAL_ORDER1; merkmalname1;merkmalunit1;merkmalvalue1;merkmalorder1; XML data after transformation: <FEATURE> <FNAME>merkmalname1</FNAME> <FUNIT>merkmalunit1</FUNIT> <FVALUE>merkmalvalue1</FVALUE> <FORDER>merkmalorder1</FORDER> </FEATURE> <FEATURE> <FNAME>merkmalname2</FNAME> <FUNIT>merkmalunit2</FUNIT> <FVALUE>merkmalvalue2</FVALUE> <FORDER>merkmalorder2</FORDER> </FEATURE> Solution: At the data model at context “FEATURE” the following function must be inserted: *[starts-with(name(.),’MERKMAL_NAME’)]. Now every node that starts with […]

Merging of DELJIT’s (Delivery just in time)

Problem: From the automotive branch two Deljit’s daily are arriving: 1 day package and 1 sequence call The day package shall be enriched with data from the sequence call. Therefore the two Deljit’s has to be merged. Solution: After identifying the day package it will be written at the internal data base by using the […]

Explaining rearrangement and auto assign feature in transformer

Problem: Assume we have a purchase order with delivery parties on line item level. Each line item may have one or more different delivery parties. The destination system has only the ability to process a delivery party on head level. Therefore the purchase order has been already grouped by delivery parties on line item level […]

How to use transformer with dynamic X-Path Expression (join) by example : Transform EDIFACT allowances

The following example illustrates the tranformation of allowances in EDIFACT. Assume the following extract from an EDIFACT message: ALC+A+1++1+DI’ PCD+3:3.5′ MOA+8:-0.7′ TAX+7+VAT+++:::0+S’ ALC+A+1++1+DI’ PCD+3:3.5′ MOA+8:-2.1′ TAX+7+VAT+++:::7+S’ ALC+A+1++1+DI’ PCD+3:3.5′ MOA+8:-0.7′ TAX+7+VAT+++:::19+S’ ALC+A+1++1+DI’ PCD+3:3.5′ MOA+8:-0.7′ TAX+7+VAT+++:::25+S’ ALC+A+1++2+EAB’ PCD+3:5′ MOA+8:-0.97′ TAX+7+VAT+++:::0+S’ ALC+A+1++2+EAB’ PCD+3:5′ MOA+8:-2.9′ TAX+7+VAT+++:::7+S’ ALC+A+1++2+EAB’ PCD+3:5′ MOA+8:-0.97′ TAX+7+VAT+++:::19+S’ ALC+A+1++2+EAB’ PCD+3:5′ MOA+8:-0.97′ TAX+7+VAT+++:::25+S’ ALC+A+1++3+FA’ PCD+3:5′ MOA+8:-0.92′ TAX+7+VAT+++:::0+S’ ALC+A+1++3+FA’ […]

Create a datamodel with redundant head and item fields per line (i.e. for Excel)

Problem: An Excel table with the following structure shall be created. The head data is redundant (repeating) per item. This example can also be used to generate an arbitrary flat structure from hierarchical data. Head.Field1 Head.Field2 Item1.Field1 Item1.Field2 Head.Field1 Head.Field2 Item2.Field1 Item2.Field2 Head.Field1 Head.Field2 Item3.Field1 Item3.Field2 Solution: The transformer is used to get through by […]

How to transform indexed fields to a wellformed structure

Problem: We have allowances in input data, which has been parsed already correctly. The input data has been designed to enumerate 1:n relations by assuming a fixed border, in example two allowances. In XML noch such restrictions would occur, but in text formats like CSV this kind of design is spread out widely. Example: There […]

How to ignore XML namespaces in transformer

Problem: The XML parser of ET-Connector honours namespaces. Later on using transformer, it may be difficult to specify the correct X-Path expression. Solution 1 Insert a star (*) to get around specifiying namespace tags Solution 2 Use qualified X-Path’s by addressing elements by namespaces

© 2017 SCHAEFER B.S. GmbH / Erich-Steinfurth-Str. 6 - 10243 Berlin / +49 (0)30 9700386 - 0 / sales@schaefer-bs.com