Excel Template - Repeat Groups that meets specific criteria

[adamodar]

What is the equivalent of the following RTF Template Code in Excel Template:

<?for-each@section:On_Address_Number_S230[./On_Notification_Date_S226/RTL_BF_Header_Summary_S223/RTL_Amount_L4_ID12 != 0]?>

XML will be of the following structure:

<R58TEST>
<On_Address_Number_S230>
<Address_Number>1</Address_Number>
<On_Notification_Date_S226>
<RTL_BF_Header_Summary_S223>
<RTL_Amount_L4_ID12>5</RTL_Amount_L4_ID12>
<Detail>
<Detail_Tag1>Line 1 Detail 1</Detail_Tag1>
<Detail_Tag2>Line 1 Detail 2</Detail_Tag2>
<Detail_Tag3>Line 1 Detail 3</Detail_Tag3>
</Detail>
<Detail>
<Detail_Tag1>Line 2 Detail 1</Detail_Tag1>
<Detail_Tag2>Line 2 Detail 2</Detail_Tag2>
<Detail_Tag3>Line 2 Detail 3</Detail_Tag3>
</Detail>
</RTL_BF_Header_Summary_S223>
</On_Notification_Date_S226>
</On_Address_Number_S230>
<On_Address_Number_S230>
<Address_Number>2</Address_Number>
<On_Notification_Date_S226>
<RTL_BF_Header_Summary_S223>
<RTL_Amount_L4_ID12>10</RTL_Amount_L4_ID12>
<Detail>
<Detail_Tag1>Line 1 Detail 1</Detail_Tag1>
<Detail_Tag2>Line 1 Detail 2</Detail_Tag2>
<Detail_Tag3>Line 1 Detail 3</Detail_Tag3>
</Detail>
<Detail>
<Detail_Tag1>Line 2 Detail 1</Detail_Tag1>
<Detail_Tag2>Line 2 Detail 2</Detail_Tag2>
<Detail_Tag3>Line 2 Detail 3</Detail_Tag3>
</Detail>
</RTL_BF_Header_Summary_S223>
</On_Notification_Date_S226>
</On_Address_Number_S230>
<On_Address_Number_S230>
<Address_Number>3</Address_Number>
<On_Notification_Date_S226>
<RTL_BF_Header_Summary_S223>
<RTL_Amount_L4_ID12>0</RTL_Amount_L4_ID12>
<Detail>
<Detail_Tag1>Line 1 Detail 1</Detail_Tag1>
<Detail_Tag2>Line 1 Detail 2</Detail_Tag2>
<Detail_Tag3>Line 1 Detail 3</Detail_Tag3>
</Detail>
<Detail>
<Detail_Tag1>Line 2 Detail 1</Detail_Tag1>
<Detail_Tag2>Line 2 Detail 2</Detail_Tag2>
<Detail_Tag3>Line 2 Detail 3</Detail_Tag3>
</Detail>
</RTL_BF_Header_Summary_S223>
</On_Notification_Date_S226>
</On_Address_Number_S230>
</R58TEST>

The expected output will be, kind of, in the following format:

Address 1
Line 1 Detail 1	Line 1 Detail 2	Line 1 Detail 3
Line 2 Detail 1	Line 2 Detail 2	Line 2 Detail 3
Address 2
Line 1 Detail 1	Line 1 Detail 2	Line 1 Detail 3
Line 2 Detail 1	Line 2 Detail 2	Line 2 Detail 3
Footer

Basically printing the information of multiple address numbers but the information needs to be printed only when the person has a non zero amount. This is easily achieved in an RTF template by adding the criteria in square brackets in the for each. Not sure how to do this in an XLS template.

 

[adamodar]

Figured it out. It is the same logic but need to have an extra "/" in front of the parent tags:

<xsl:for-each select=".//On_Address_Number_S230[.//On_Notification_Date_S226//RTL_BF_Header_Summary_S223/RTL_Amount_L4_ID12 != 0]">