You can use the Tools.*
utility providers supplied by FINBOURNE in any Luminesce query.
To... | Use the ... provider |
Return column names and data types for a table | Tools.Describe |
Parse JSON documents | Tools.JsonExpand |
Use Mustache templates to format tables into text output | Tools.Mustache |
Generate a range of values | Tools.Range |
Split strings | Tools.Split |
Pivot data from rows into columns | Tools.Pivot |
Unpivot data from columns into rows | Tools.Unpivot |