Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

XSLT transformation

edited Jun 12, 2019 1:33PM in Integration 3 comments

Summary

Select a distinct value from a DB resultset array

Content

Hi Folks,

Our requirement is to read data from a MS SQL server DB and transform to fusion FBDI templates to trigger an ESS job. Data that comes from SQL server will be the resultset from select statements . Is it possible to pick distinct elements in an array using the XSLT functions in OIC . Kindly share examples if available.

E.G : Code[] array with multiple lines and columns might have lines with one column that has the same value . How do i pick the distinct value?

909950031      
909950031
909950031
998765432
909950031
123456789
909950031

I need the XSLT to return

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!