XML Convert Duplicate Data Items

Question
9

Hello there,

I have tested this now and it works as expected for the issue described. I get this result:

    <QualificationSubject>
      <QUALSUBJECT>100443</QUALSUBJECT>
      <QUALPROPORTION>50</QUALPROPORTION>
      <QUALSUBJECT>100444</QUALSUBJECT>
      <QUALPROPORTION>50</QUALPROPORTION>
    </QualificationSubject>
  </Qualification>

Which is great.

However I am getting this issue with another section when it comes to parent TAGS.

        <EntryQualificationAward>
          <QUALRESULT>H4</QUALRESULT>
          <QUALTYPEID>IB</QUALTYPEID>
          <QUALRESULT>H4</QUALRESULT>
          <QUALTYPEID>IB</QUALTYPEID>
          <QUALRESULT>H3</QUALRESULT>
          <QUALTYPEID>IB</QUALTYPEID>
          <QUALRESULT>H3</QUALRESULT>
          <QUALTYPEID>IB</QUALTYPEID>
          <QUALRESULT>H6</QUALRESULT>
          <QUALTYPEID>IB</QUALTYPEID>
          <EntryQualificationSubject>
            <SUBJECTID>E12</SUBJECTID>
            <SUBJECTID>H91</SUBJECTID>
            <SUBJECTID>70H</SUBJECTID>
            <SUBJECTID>P11</SUBJECTID>
            <SUBJECTID>M11</SUBJECTID>
          </EntryQualificationSubject>
        </EntryQualificationAward>

While I am expecting this output:

        <EntryQualificationAward>
          <QUALRESULT>H4</QUALRESULT>
          <QUALTYPEID>IB</QUALTYPEID>
          <EntryQualificationSubject>
            <SUBJECTID>E12</SUBJECTID>
          </EntryQualificationSubject>
        </EntryQualificationAward>
        <EntryQualificationAward>
          <QUALRESULT>H4</QUALRESULT>
          <QUALTYPEID>IB</QUALTYPEID>
          <EntryQualificationSubject>
            <SUBJECTID>H91</SUBJECTID>
          </EntryQualificationSubject>
        </EntryQualificationAward>
        <EntryQualificationAward>
          <QUALRESULT>H3</QUALRESULT>
          <QUALTYPEID>IB</QUALTYPEID>
          <EntryQualificationSubject>
            <SUBJECTID>70H</SUBJECTID>
          </EntryQualificationSubject>
        </EntryQualificationAward>
        <EntryQualificationAward>
          <QUALRESULT>H3</QUALRESULT>
          <QUALTYPEID>IB</QUALTYPEID>
          <EntryQualificationSubject>
            <SUBJECTID>P11</SUBJECTID>
          </EntryQualificationSubject>
        </EntryQualificationAward>
        <EntryQualificationAward>
          <QUALRESULT>H6</QUALRESULT>
          <QUALTYPEID>IB</QUALTYPEID>
          <EntryQualificationSubject>
            <SUBJECTID>M11</SUBJECTID>
          </EntryQualificationSubject>
        </EntryQualificationAward>

My XLS input headers are labeled the following way:

Engagement.EntryProfile.EntryQualificationAward.QUALRESULT
Engagement.EntryProfile.EntryQualificationAward.QUALTYPEID Engagement.EntryProfile.EntryQualificationAward.EntryQualificationSubject.SUBJECTID Engagement.EntryProfile.EntryQualificationAward.QUALRESULT
Engagement.EntryProfile.EntryQualificationAward.QUALTYPEID Engagement.EntryProfile.EntryQualificationAward.EntryQualificationSubject.SUBJECTID Engagement.EntryProfile.EntryQualificationAward.QUALRESULT
Engagement.EntryProfile.EntryQualificationAward.QUALTYPEID Engagement.EntryProfile.EntryQualificationAward.EntryQualificationSubject.SUBJECTID Engagement.EntryProfile.EntryQualificationAward.QUALRESULT
Engagement.EntryProfile.EntryQualificationAward.QUALTYPEID Engagement.EntryProfile.EntryQualificationAward.EntryQualificationSubject.SUBJECTID Engagement.EntryProfile.EntryQualificationAward.QUALRESULT
Engagement.EntryProfile.EntryQualificationAward.QUALTYPEID Engagement.EntryProfile.EntryQualificationAward.EntryQualificationSubject.SUBJECTID