Facing Challenge in Comparing 2 parallel groups in RTF having multiple records

Ankur.Bansal

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.

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24605/facing-challenge-in-comparing-2-parallel-groups-in-rtf-having-multiple-records

Are you not able to handle this at query level?

Thanks.

Ankur.Bansal

https://community.oracle.com/products/oracleanalytics/discussion/comment/63865#Comment_63865

@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.

Sandeep S. Chauhan-Oracle

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 Partners