This article outlines how to configure Data Explorer to run over HTTPS on port 443.These instructions reflect a configuration used in a development/test environment. Prerequisites
In Quintessence, several functions support header notation, allowing you to reference columns by their header names rather than their positional index. This improves readability, reduces
Quintessence Studio is a desktop application used to browse data, create reports and custom calculations, and manage security for users and groups. It provides a
This article explains how to call Quintessence functions from Python using the Quintessence.py package. We will demonstrate this using a Report call. In Excel, the
This article describes how to create a self‑signed certificate for use with the Quintessence Engine. The certificate generated through these steps includes all required DNS
Quintessence functions return results following Excel’s population behavior, which may operate in one of two modes: The difference between these modes determines whether Excel reserves
The Sparse() function, together with Excel’s implicit intersection operator (=@), allows the user to edit blank cells inside a returned result. When the function recalculates,
The ExportExcel() function takes a data block and exports it into an Excel workbook. The function can also append worksheets to existing Excel workbooks. This
The ExportCSV() function takes a data block and exports it into a CSV file. This function is only available in the Quintessence Language (for example,
Similar to CsvToArray, the ImportCsvText() function converts a block of CSV-formatted data into an array. However, this function also allows you to apply filter expressions
View More