Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Ability for OUTER JOIN transform to know JOIN match type for LEFT and RIGHT

Description

Would be useful if the transform for any type of OUTER JOIN could be told whether a particular match was

1. an INNER match
2. left only (OUTER LEFT)
3. right only (OUTER RIGHT)

Conclusion

None
0% Done
Loading...

Activity

Show:

Anthony Fishbeck April 18, 2017 at 5:04 AM

Currently implementing as

SELF.myfield := IF (MATCHED(LEFT), l.myfield, r.myfield);
SELF.ml := MATCHED(LEFT);
SELF.mr := MATCHED(RIGHT);

Anthony Fishbeck May 9, 2016 at 9:45 PM

If you don't think the change would be too overly complicated and you want me to work on it, feel free to assign to me, and comment with an ECL example of how you think it should work. But it's also fine if this is just one of those things it may be easier or better if you just did.

Fixed
Pinned fields
Click on the next to a field label to start pinning.

Details

Components

Assignee

Reporter

Priority

Compatibility

Major

Fix versions

Pull Request URL

https://github.com/hpcc-systems/HPCC-Platform/pull/9857

Created May 9, 2016 at 9:43 PM
Updated June 21, 2017 at 8:34 AM
Resolved June 21, 2017 at 8:34 AM