Function Name Description
createIfHasValue Produces empty value if argument is not empty; ResultList. SUPPRESS otherwise
createIfExistsAndHasValue Produces empty value if argument is not empty and exists; ResultList. SUPPRESS otherwise
createIfHasOneOfSuchValues Produces empty value when the first argument has one of the values passed as a constant in the second argument (separated by a semicolon); ResultList. SUPPRESS otherwise
passIfHasValue Passes all context values and empty values are replaced by ResultList. SUPPRESS
assignValueByCondition Passes a value from the third argument when the corresponding value from the first argument has one of the values contained in the second value (these conditions are separated by a semicolon); passes ResultList. SUPPRESS otherwise
simpleUseOneAsManyAndSplitByEachValue Uses the first argument (the context should have exactly one value) as often as the length of the second context indicates and splits the result by each value.
simpleUseOneAsMany Uses the first argument (the context should have exactly one value) as often as the length of the second context indicates
deleteSuppress Maps every context value to itself when not null and not ResultList. SUPPRESS – maybe the context queue is shorter
getFirstContextValue Returns the first non-empty context value or ResultList. SUPPRESS if no such value exists.
existsAndHasValue Produces "true" if the argument is not empty; "false" otherwise
existsAndHasOneOfSuchValues Produces "true" if the first argument has one of the values passed as a constant in the second argument (separated by a semicolon); otherwise "false"
contextHasOneOfSuchValues Produces a single "true" if the first argument (a context queue) contains one of the values passed as a constant in the second argument (separated by a semicolon); otherwise "false"
useOneContextAsMany Uses the first argument context as often as values exist in the second argument context.
concatToOneQueue Puts all arguments sequentially into one queue
deleteMultipleContextValues Removes all multiple values from the context, leaving only the first.
concatContextValues Concatenates all values of a context separated by second argument
formatByContextExample Format contexts in first queue (input queue) by values (representing contexts) in second queue (example queue); requirement: number of contexts in inputQueue = number of values in example queue
createMultipleCopies Duplicates first argument's value as often as value in second argument indicates; contexts must have the same size
fragmentSingleValue Fragments the first argument into a max. number of pieces (given by the second argument) of length from the third; the last one may be shorter. All arguments are treated like constants.
concatTwoQueuesToOne Puts all arguments sequentially into one queue
rearrangeByKey Rearranges the third argument by the corresponding key set in the second argument formatted by the first argument
getValueByIndex Returns a value from a context(arg1) by given index(arg2) (starting at 1)
createNumberRange Creates an empty string for each number missing between first and second argument values
createContextsForFixedBlockSize Splits context in first argument into blocks defined in size by parameter
buildBlocksAndGetValueByIndex Splits context in first argument into blocks defined in size by parameter and returns value at index given by second argument
UDFNodePool Function Library

Leave a Reply

Your email address will not be published.

Time limit is exhausted. Please reload CAPTCHA.