<element id="194070" > <types> <type id="445"/> <type id="643"/> </types> </element>I can flatten the xml and recreate a table which looks like this...
element.id | type.id.1 | type.id.2 194070 445 643But in order to build a association table for the m:m relationship I need this;
element.id | type.id 194070 445 194070 643Can anyone offer a way to create this association table ?
If you read the XML document by the XML reader with Feature Paths option (Elements to Match: element), the reader feature type will configure a list attribute named "types.type{}.id". Then, you can use the ListExploder on the list "types.type{}" to create the required data structure.
Takashi
+15If you explode this list you get your m:m table.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
