Support TSQL PIVOT Operator
Working with poorly designed SQL database with absolutely no normalization. Have many tables with repeating groups, ie: item1, item2, item3, item4, item5, etc. The TSQL Pivot operator allows me to turn a single row with 5 items into 5 rows. Then I could ForEach through the rows.
We encourage you to resolve this unfortunate data problem outside of Windward. Issues with the structure of your data may be solved with changes to the database, or a view for your data that you can use inside the Designer. For this reason, we are declining this idea for development. Thank you for your suggestion and please submit any other ideas you have to improve our products.