Miscellaneous Functions

Macro Name	Returns	Function
BUFFER	One column for each input column	Copies the input data range, and updates dynamically
COLUMN	One column for each input column	Creates new columns, vertically concatenating the input values in each column
CONSTANT	One column for each input column	Copies the input data range one time (no dynamic update)
COUNT_DIFF	Two columns	Returns each unique value in the input with a count of the number of times that value appeared
CV_FOLDS	One column with a value for each row of the shortest input column	Divides input patterns inton folds of data for cross-validation
DATALINK	One column for each column of linked data	Creates an internal link to data in a IBM® PredictiveInsight spreadsheet
DDELINK	One column for each column of linked data	Creates an external link to data from another Windows™ application
DECIMATE	MAX_VALUE columns (one column for each output value)	Decimates a column of numbers into multiple columns where a one indicates the index value
EXTRACT	One column for each input column	Extracts rows given the values in a predicate column
IF	One column with a value for each row of the shortest input column	Begins a conditional statement if-then-else statement
INIT	One column	Initializes previous time step values for a recursive function
ISERROR	One column with a value for each row of the shortest input column	Returns a one if any value in the input row contains an error (???) cell, else zero
ISMEMBER	One column for each input column	Tests an input range against a "table" of values, returning one if a value is contained in the table, else zero
MAXINDEX	One column with a value for each row of the shortest input column	Returns the column index of the nth (first, second, third, and so on) maximum value for each row of the specified column
RANK	One column for each input column	Divides data into nbins (default 10) groups, each with approximately an equal number of distinct values, and returns the group into which each row of data falls
SORT	One column for each input column	Sorts the specified data range in ascending or descending order