Uploaded image for project: 'HPCC'
  1. HPCC
  2. HPCC-15514

ECL JOIN syntax suggestion (for all fields in a dataset EXCEPT listed ones)

    XMLWordPrintable

    Details

    • Type: Suggestion
    • Status: Accepted
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 5.4.10
    • Fix Version/s: None
    • Component/s: Language
    • Labels:
      None
    • Compatibility:
      Major

      Description

      Currently, you can shorten a series of JOIN comparisons by doing the following:

      Res := JOIN(left_ds, right_ds, LEFT = RIGHT, TRANSFORM(LEFT), LEFT ONLY);

      When you want all fields in the datasets compared.

      Would there be any way to do something similar, but allow for EXCEPT syntax? (similar so the SORT/GROUP/DEDUP/ROLLUP)

      Gavin Halliday

        Attachments

          Activity

            People

            • Assignee:
              anybody Available for anyone
              Reporter:
              kev77log Kevin Logemann
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: