Home arrow Reference arrow Query, TextColumnNames

CONTENT WARNING

This site refers to our older, server-based product. If you are interested in our new, Excel-based product, please see our main web site at http://www.nextanalytics.com

Query, TextColumnNames
This function assigns the text column captions for each of the text columns loaded from the query.

Syntax:

Query, TextColumnNames, semicolonDelimitedTextColumnNames

Parameters:

semicolonDelimitedTextColumnNames – list of captions for each text column loaded by the query, separated by semicolons.

Examples:

Query,TextColumnNames,Product Line;Product Category

The two text columns loaded by the query are to be labelled ‘Product Line’ and ‘Product Category’.

Comments:

Note that if the SQL query returns fields with names starting with rowlabel_, text_ and numeric_ then the fields will be imported as Row Labels, Text Columns and Numeric Columns respectively, making this function unnecessary.

 

Reference

Installation - Java