Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 19 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics & AI Challenge
- Find Partners
- For Partners
Issue in RTF template while trying to Grouping based on particular columns.
We had a BIP Query which is having two datasets G1 and G2. Need to compare Person Number and Date field from G1 with G2 and if it is same then result should be produced . But facing some challenges in handling grouping in Template. Attached syntax here which I used in template.
<?for-each-group:G_1;./PERSON_NUMBER?><?xdoxslt:set_variable($_XDOCTX, 'SAMPLE', PERSON_NUMBER)?> ---First for each
<?for-each-group:../G_2[PERSON_NUMBER_1 = xdoxslt:get_variable($_XDOCTX, 'SAMPLE1')];./PERSON_NUMBER_1?> --Second For each.
Second for each is not working properly. Any suggestion on this issue?