Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 9 Oracle Analytics Lounge
- 182 Oracle Analytics News
- 39 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 62 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Facing Challenge in Comparing 2 parallel groups in RTF having multiple records
I'm facing a challenge within an RTF template. I need to compare two groups of data. These groups are parallel, share a common parent, and may contain duplicate records. My goal is to identify and exclude records from the first group that also exist within the second group.
Answers
-
Are you not able to handle this at query level?
Thanks.
0 -
@MandeepGupta , this is a seeded HCM Extract based report, so no changes could be made at the XML level, we will have handle this at template level only.
0 -
Hi Ankur, I would suggest you to handle in Datamodel via customizing the seeded report as there could be performance issue to handle complex logic in RTF.
if you want to handle in RTF, you can try using variable and compare the values, something like this -for ex:
<?for-each:ROWSET/ROW1?><?xdoxslt:set_variable($_XDOCTX, 'v_name', NAME)?><?for-each:../ROW2?><?if:xdoxslt:get_variable($_XDOCTX,'v_name')= NAME?><?NAME?><?end if?><?end for-each?> <?end for-each?>for Data:
Output will be -
Eleni Zlotkey
Karen Partners1
