How Can I access child loop element inside parent for each loop based on condition in rtf template

Content

Nested for each to get child element based on parent loop condition

I have two different groups in xml files 1. GLB_PAY_ARCH_PR_EARNINGS and 2.GLB_PAY_ARCH_PR_HOURS_X_RATE both having common field

REPORTING_NAME .I need data like for every Earninngs_name from (GLB_PAY_ARCH_PR_EARNINGS).it should return hours from (GLB_PAY_ARCH_PR_HOURS_X_RATE) group.

Getting Blank result for below code

Output Example:

Earning_name                 Hours

EAR1                                 12

EAR2                                  8

 

 

<?for-each-group:/DATA_DS/G_1/FILE_FRAGMENT/PAYSLIP/PAYMENT_RECORD/GLB_ARCH_PR/GLB_PAY_ARCH_PR_INFO/GLB_ARCH_CBID/GLB_PAY_ARCH_CBID_INFORMATION/GLB_ARCH_TRU/GLB_PAY_ARCH_PR_EARNINGS;./REPORTING_NAME?>