Supporting functionality (Tools.)

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

Execute a string of SQL

Tools.ExecSql

Parse JSON documents

Tools.JsonExpand

Parse CSV, Text and similar from cells within a table

Tools.Parse.Csv

Parse XML from cells within a table

Tools.Parse.Xml

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