You can extract order information from a Microsoft Word document and write the order information to an order header table and an order detail table. Configure an Unstructured Data transformation to call a Data Transformation parser service and pass the name of each Word document to parse.
Data Transformation
Engine opens the Word document, parses it, and returns the rows to the Unstructured Data transformation. The Unstructured Data transformation passes the order header and order details to the relational targets.
The mapping has the following objects:
Source Qualifier transformation. Passes each Microsoft Word file name to the Unstructured Data transformation. The source file name contains the complete path to the file that contains order information.
Unstructured Data transformation. The input type is file. The output type is buffer. The transformation contains an order header output group and an order detail output group. The groups have a primary key-foreign key relationship.
The Unstructured Data transformation receives the source file name in the InputBuffer port. It passes the name to
Data Transformation
Engine.
Data Transformation
Engine runs a parser service to extract the order header and order detail rows from the Word document.
Data Transformation
Engine returns the data to the Unstructured Data transformation. The Unstructured Data transformation passes data from the order header group and order detail group to the relational targets.
Relational targets. Receive the rows from the Unstructured Data transformation.
ASK INFAPreview
