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 | |
Execute a string of SQL | |
Parse JSON documents | |
Parse CSV, Text and similar from cells within a table | |
Parse XML from cells within a table | |
Use Mustache templates to format tables into text output | |
Generate a range of values | |
Split strings | |
Pivot data from rows into columns | |
Unpivot data from columns into rows |