Skip to:

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

Document JOIN ...KEEP(n) applying per left row

Environment

UK DEV HTHOR

Description

The following code snippet creates a dataset of 10 copies of every date for June 2021.

It then JOINs that to a dataset containing a single record for every day of June 2021, with the qualifier KEEP(3).

However the resultant dataset still shows 10 records for every date. The qualifier has not taken effect.

   

Conclusion

None

Attachments

1

Activity

Show:

Gavin Halliday August 19, 2021 at 8:42 AM

you might want to consider revising the wording.

Allan Wrobel August 19, 2021 at 8:00 AM

Thanks Dan,

Ok then its an issue with the documentation.

The documentation should reflect what is 'really' going on.

I took the documentation at its word:

Yours
Allan

Dan Camper August 18, 2021 at 7:06 PM
Edited

I think you need to reverse your left and right in the final join:

KEEP(n) is really "keep n matches for every left matching record". You would want your unique dates to be on the left, in your use case.

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

Details

Components

Assignee

Reporter

Priority

Compatibility

Point

Fix versions

Pull Request URL

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

Affects versions

Created August 18, 2021 at 4:13 PM
Updated August 19, 2021 at 2:15 PM
Resolved August 19, 2021 at 2:15 PM