XML Parsing

[dholder15]

If I have to parse for each record with the two titles how can I do that? I understand using the child name to specify but it only works for one. I feel like I'm missing something. 

[Yoshiro_Fujimori]

Hi @dholder15 ,

The persons in your data does not seem to have two titles.

Your original data

<PersonNm>TP Gent</PersonNm>
<TitleTxt>EXECUTIVE DIRECTOR</TitleTxt>

<PersonNm>Cam Payne</PersonNm>
<TitleTxt>ASSISTANT DIRECTOR</TitleTxt>

<PersonNm>Tyler Nubume</PersonNm>
<TitleTxt>EXECUTIVE DIRECTOR</TitleTxt>

Do you mean you want to add another title to a person?

If so, you may want to put then in one element, like this;

(I added a root element to deal with it as an independent XML document.)

<Document>
    <Person>
        <PersonNm>TP Gent</PersonNm>
        <TitleTxt>EXECUTIVE DIRECTOR</TitleTxt>
        <TitleTxt>ROCK SINGER</TitleTxt>
    </Person>
    <Person>
        <PersonNm>Cam Payne</PersonNm>
        <TitleTxt>ASSISTANT DIRECTOR</TitleTxt>
    </Person>
    <Person>
        <PersonNm>Tyler Nubume</PersonNm>
        <TitleTxt>EXECUTIVE DIRECTOR</TitleTxt>
    </Person>
</Document>

If you read this with Input Data tool, the output would be as below.

PersonNm	TitleTxt	TitleTxt_2
TP Gent	EXECUTIVE DIRECTOR	ROCK SINGER
Cam Payne	ASSISTANT DIRECTOR
Tyler Nubume	EXECUTIVE DIRECTOR

I hope this helps.

Yoshi