Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.
Originally posted by: mmarinelliNode Name: Interval Inspection
Node Category: Profiling and Patterns
Use Case: Use this node to determine if a sequence of rows conforms to an iterative sequence
Tested on Release: 4.5.0
External Dependencies: None
Practical Usage Example: An example use of this node has been provided in the prototype examples graph which is released in conjunction with the prototype library. Please see that graph for a executable use case.
Node Documentation:
Functional Description:
Tests a sequence of values across a row set for adherence to an iteration value defined by a specified interval. For example,within a field FIELD1 which contains the values 1,2,4 across 3 rows, testing for an interval value of 1 will identify the thirdrow as exceeding the iteration value.
Parameters:
-
SequenceExpr: The value which will be tested across the row set defined by the GroupBy parameter
-
IntervalValue: The interval to be tested at each iteration of the value set; may be a positive or negative, whole or rational number
-
IntervalExact: If set to true, tests for exact interval sequencing (e.g. exactly 1.5, 2, 2.5 for IntervalValue 0.5).
If set to false, so long as the next value in the sequence exceeds the last + interval, a sequenced value
is found (e.g. IntervalValue 1 will yield sequenced values among 1,2,4,5,7).
Known Limitations: None