Now I have an other issue.
tFileInputMSXML send all nested element witout balise in one colonne.

Example:
<Root>
  <Element>
    <A>1</A>
    <B>2</B>
    <B>3</B>
    <B>4</B>
  </Element>
  <Element>
    <A>8</A>
    <B>9</B>
  </Element>
</Root>
Et Send me 2 Row
First one:
1
    2
    3
    4

Second row
8
    9

It isn't the best result that we can hope...

If you have an idea...

Bye

I just forgot.
I use TOS 5
Thank for your help.

Hi,

I'm using now the Talend 4.1.

@mac: how did you solve your problem.

Please give tips.


Seb

We had some similar situation, but not so much volume.  We also used multiple XML inputs (is the MSXML new, didn't see it before, we had multiple XML components).  I think Talend is fundamentally row based, so hierarchal data is a problem.  You can get a normalized data structure using the XML input components.  After that you can filter or aggregate to make it denormalized.  Hope that helps

I have following complex data file, consisting of multiple schema for master data
and finally addresses. For simplification I give only this reduced example
(persons with multiple addresses and referencing master data from the beginning
of the XML):

<data>
    <countries>
        <country code="F" name="France" />
        <country code="US" name="USA" />
        <country code="GB" name="Great Britan" />
        <country code="AU" name="Australia" />
        [...]
    </countries>   
    <address-types>
        <address-type code="H" desc="Home address" />
        <address-type code="O" desc="Office address" />
        <address-type code="V" desc="Vacation address" />
        [...]
    </address-types>
    <role-types>
        <role-type code="D" name="Developer" />
        <role-type code="WD" name="Web developer" />
        <role-type code="BE" name="Business engineer" />       
        <role-type code="PL" name="Project leader" />
    </role-types>
   
    <persons>
        <person id="2">
            <name>Mathieu</name>
            <firstname>Francois</firstname>
            <gender>male</gender>
            <roles>
                <role code="PL" />
            </roles>
            <addresses>
                <address type="H>
                    <street>street1</street>
                    <zip>12345</zip>
                    <town>town1</town>
                    <country code="F"/>
                </address>
                <address type="W>
                    <street>street2</street>
                    <zip>44444</zip>
                    <town>town2</town>
                    <country code="AU"/>
                </address>
            </addresses>
        </person>
        <person id="555">
            <name>Charol</name>
            <firstname>Marianne</firstname>
            <gender>female</gender>
            <roles>
                <role code="WD" />
                <role code="D" />
            </roles>
            <addresses>
                <address type="H>
                    <street>street3</street>
                    <zip>45523</zip>
                    <town>town3</town>
                    <country code="F"/>
                </address>
                <address type="W>
                    <street>street4</street>
                    <zip>44444</zip>
                    <town>town4</town>
                    <country code="AU"/>
                </address>
            </addresses>
        </person>
        [...]
    </persons>
</data>

As you see, the first sections (/data/countries/country, /data/address-types/address-type,
/data/role-types/role-type and so on), give master data used afterwards for the defined
persons.

My approach is to use multiple tFileInputMSXML the multiple schema are used to extract
these sections. Maybe there is a more elegant solution, but it seems to work so far. (tips welcome! )

But here my main question:
One tFileInputMSXML has a definition for giving me the different persons, where I map
the person properties to variables (mainly String or Integer values). The person itself
contains again list (roles, addresses) of other schemas I want to use finally with a
tMap for mapping the data to a database (person table, foreign linked to a person_address
table).

How can I process now these sub-structures/lists (roles, addresses)? Do you recommend
somehow using e.g. tExtractXMLField to get another feed of roles/addresses from the
person? As I am juggling around with my first Talend project, I have the strong feeling,
I am doing things much to complicated (for sure there is a component for processing imports
of such hierarchical data structures).

Thanks for any tips and help!!!