Summary

Regroup and Filter Data Regardless of the XML Source

Content

Hello everyone,

I am stuck with a RTF template I want to make for JDE

I am trying to create a customer statement in XML from the standard R/E Customer Statement R155001, so if anyone used in the past I would really appreciate any help

The problem is the following:

The RDA creates 3 main sections of the document (Header, Main Body and Footer), but the source output is like:

Headers

     Header 2

     Header 3

Main Body

     Header 1

     Details 1

etc (no there no typo there)

In every node there is a unique value (PageHeaderNumber) which is always 1 for the first statement, 2 for the next etc

(if the source contains 10 statements it is from 1-10)

I want to filter nodes, regardless of their position in the structure and put them in the same level

Something like:

Take all nodes where PageHeaderNumber=1 (page break)