Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1692

Include an example of the LOOKUP function in the Ref Guide

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Major
    • 7.4.1, 7.5
    • 7.4
    • Documentation
    • None

    Description

      Once again I confused myself while trying to use the LOOKUP function. The first three arguments are all quoted strings. A simple example might help demonstrate this to the reader. I believe this may work as it follows the descriptive text.

      SELECT LOOKUP('ModelName.StatePostalCodes', 'StateDisplayName', 'PostalCode', Table.WhatStateMatchesThisPostalCode) AS LookedUpStateName FROM Table

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            pnittel_jira Paul Nittel (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: