The Quintessence utility functions are available in both the Quintessence Excel^® Addin and Quintessence Application. These functions perform useful manipulations on data.

AlignToAxes

ArrayToString

Colouring

CreateMatrix

CsvToArray

Depivot

FilterData

Fx

GroupBy

ImportCSV

ImportExcel

ImportMDX

ImportODBC

ImportText

Join

Merge

MultiJoin

Null

Pivot

ReplaceArray

SetDifference

SetDimension

SetIntersect

SetUnion

Sieve

SoapRequest

SortData

Span

StringToArray

SubArray

SubstituteArray

Transform

TransposeArray

TypeCast

Unique

WebRequest

XmlToArray