There is no function available in Oracle Integration Cloud to find distinct of node values.
distinct function can be used in xsl , but that can be done from backend only which may invalid the mapper sometime.
We can use the following to get rid of repetitions / find distinct.
This needs to be applied in the xsl . Will post the examples shortly.
[not(nsmpr7:LOC=preceding::*)]
$StageRead/nsmpr2:ReadResponse/nsmpr4:RecordSet/nsmpr4:HeaderRecord[not(nsmpr4:SequenceNumber=preceding::*)] --> This will pick HeaderRecord for distinct SequenceNumber
$ReadInChunk/nsmpr4:ReadResponse/nsmpr7:RecSet/nsmpr7:Rec[not(nsmpr7:LOC=preceding::*)] --> This will pick HeaderRecord for distinct LOC
distinct function can be used in xsl , but that can be done from backend only which may invalid the mapper sometime.
We can use the following to get rid of repetitions / find distinct.
This needs to be applied in the xsl . Will post the examples shortly.
[not(nsmpr7:LOC=preceding::*)]
$StageRead/nsmpr2:ReadResponse/nsmpr4:RecordSet/nsmpr4:HeaderRecord[not(nsmpr4:SequenceNumber=preceding::*)] --> This will pick HeaderRecord for distinct SequenceNumber
$ReadInChunk/nsmpr4:ReadResponse/nsmpr7:RecSet/nsmpr7:Rec[not(nsmpr7:LOC=preceding::*)] --> This will pick HeaderRecord for distinct LOC
No comments:
Post a Comment