Question

6
Replies
295
Views
Eugene Roytfeld (EugeneR7)
Deutsche Bank
Vice President
Deutsche Bank
US
EugeneR7 Member since 2013 30 posts
Deutsche Bank
Posted: September 26, 2016
Last activity: May 2, 2017
Posted: 26 Sep 2016 16:10 EDT
Last activity: 2 May 2017 7:47 EDT
Closed

In-memory join

Is there any out of box feature where we can perform an in-memory join?


For example:


I have a set of web services which provide raw data and data types back to pega in key-value form, such as <someKey>1234</someKey>. The key value has a UI label in a separate reference data page, such that 1234 = "my field description"


The way for us to display the description is essentially to loop through the reference data page, for each key, to identify the description.


Had the service data been part of the same database, then it would be very easy to perform a join to get this info. However, if two sources are externalized, we have to iterate for each key to get the proper label.



What i'm looking for is the ability to, connect 2 pages based on key.



SourcePage


.pxResults()


.someProperty = 1234



RefPage


.pxResults()


.key = 1234

Is there any out of box feature where we can perform an in-memory join?

For example:

I have a set of web services which provide raw data and data types back to pega in key-value form, such as <someKey>1234</someKey>. The key value has a UI label in a separate reference data page, such that 1234 = "my field description"

The way for us to display the description is essentially to loop through the reference data page, for each key, to identify the description.

Had the service data been part of the same database, then it would be very easy to perform a join to get this info. However, if two sources are externalized, we have to iterate for each key to get the proper label.

What i'm looking for is the ability to, connect 2 pages based on key.

SourcePage

.pxResults()

.someProperty = 1234

RefPage

.pxResults()

.key = 1234

.desc = "my Label"

and have, possibly a resulting page, if 2 pages joined on .someProperty = .key

JoinedPage

.pxResults()

.someProperty = 1234

.key=1234

.desc = "my Label"

***Updated by moderator: Lochan to add Categories***

Low-Code App Development Data Integration Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.