Visokio website     Downloads     Video tutorials     KnowledgeBase  
Scripting: Using arrays of data (2.8+) - Visokio Forums
Scripting: Using arrays of data (2.8+)
  •     steve July 16, 2012 11:23AM
    Version 2.8, available shortly to alpha partners, introduces a new function "dataArray", for use in Javascript. It retrieves a two-dimensional array of cell data for bulk processing and transformation.

    You can use Javascript in Omniscope in the SCRIPT function in formulae, and to do HTML pre-processing in the Content view.


    dataArray(fields, rowSubset, includeFieldNames)

    Argument "fields": An optional array of field names. If omitted, all fields are retrieved.
    Argument "rowSubset": An optional data subset, as returned by the subset function.
    Argument "includeFieldNames": if true, the first 'row' in the returned 2d array 'table' will be the field names.

    Returns: A two-dimensional array of cell data, indexed as [column][row], with indexes numbered from 0 to n-1.

    See attached example, using dataArray inside a Content View.
    dataArray.iok 8K
  •     steve July 16, 2012 12:17PM
    Please note that scripting functionality is now documented here:
  •        CRead July 30, 2012 9:40AM
    Steve, is there any intention to bring functionality like this to normal columnar formulas? I understand it likely wouldn't be able to return more than one column, but there are ways around that using text based operations.
  •     steve July 31, 2012 3:16AM
    You should be able to use this with the SCRIPT function:
    Let me know how you get on.
  • admin May 10, 2013 11:55AM
    This feature is now publicly available in 2.8 beta:


It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership