January 12, 2010
Posted by admin
transforming a flattened file to hierarchical canonical schema
I ran into a challenge having to map a flattened file data, from SAP’s RFC call, to a hierarchically structured canonical schema. Source: <YITAB> <RecType /> <CDATA /> </YITAB> Canonical: <Header> <Detail> <DetailSpecialInstruction /> </Detail> <HeaderSpecialInstruction /> </Header> rules: 1. if RecType = 001 then header record; if RecType = 002 then Detail Record 2. [...]