Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

How to solve this self joining problem?

edited Jun 24, 2015 10:01AM in Design Tools & Output Technologies - JDE1 (MOSC) 1 commentAnswered

Here's my fields and data in a business view

Name|Co-Worker|Related

John|Jane

Smith|Ken

Jane|John

In the Do Section of the UBE, I will look in Co-Worker column and if other records have the same value under the Name column then I'll put a letter X in the Related column for that record.

For example, given the above data set, the end result is below. John and Jane are related because John has Jane under his Co-Worker column and vice versa, Jane has John under her Co-Worker column. So John and Jane have X in the Related column. Smith does not have any records that have Ken so Smith does not have letter X

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center