Van Halbert created TEIID-2497: ---------------------------------- Summary: Add support for DECODE(column, column_value, column_to_replace_with) Key: TEIID-2497 URL: https://issues.jboss.org/browse/TEIID-2497 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.7.6 Reporter: Van Halbert Assignee: Steven Hawkins Looking at pivot and trying to use it like: Select salesperson, SUM(DECODE(product, 'CarA', amount)) as ProductCarA, SUM(DECODE(product, 'CarB', amount)) as ProductCarB, SUM(DECODE(product, 'CarC', amount)) as ProductCarC Group By salesperson Teiid's Decode requires you to know the value to substitute, with this option, it can be dynamically substituted at run time. See: http://www.clearpeaks.com/blog/data-warehousing/pivot-data-in-sql -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira