Looking to pull out HL7 Fields data to put into columns in a SQL table. How to handle the repeated fields & segments data to SQL.
Operations over the extracted data in SQL server can help for Analysis.
Appreciate your Help!!
Ensemble supports Data Transformation Language (DTL) for describing data transformations. DTL is an XML language. Ensemble provides wizards and graphical tools for creating, editing, and testing DTL transformations. A data transformation is a Caché class like the following. If you prefer you can use Studio to edit the class definition directly and bypass the wizards and graphical tools.