If you selected File as the output type, specify the following information in the As panel: Output options that do not apply to a particular analytical operation are disabled. Sequence option to determine if one or more fields in the active tableĪre ordered sequentially, or to identify out-of-sequence items. The fields being tested, and treats the Amount field as sorted ascending. The sequence test uses a different direction from one of Returns 5 sequence errors: SEQUENCE ON Date Amount The fields being tested, and treats the Amount field as unnested. The sequence test uses a different order of priority from Returns 2 sequence errors: SEQUENCE ON Amount D Date The sequence test uses the same order of priority and directionĪs the fields being tested. Returns 0 sequence errors: SEQUENCE ON Date Amount D (secondary key field, nested, descending) The examples below demonstrate results thatĪre valid or invalid based on whether the testing order matches the nested sort order and the direction of the values in the Date and Amount key fields. The direction of the sequential order – ascending or descending Key field, secondary key field, and so on. Of priority as the sort order or index order priority – primary Valid, you need to select the fields for testing in the same order Order of two or more fields in combination, for the results to be For example, when testing the followingĬolumn of values for ascending order, Analytics reports two sequence Any values after the break thatĪre out of sequence when compared to values before the break are Reported if a pair of values constitutes a break in the sequence.Ī break, the sequence begins anew, using the second of the paired Second value, the second value against the third, and so on, progressingĭown the column by comparing paired values. Sequence option compares the first value in a column against the Some sorting subtleties exist in the non-Unicode edition of Analytics –įor example, the default sort sequence dictates that all uppercaseĪlpha characters are sorted before all lowercase alpha characters. Sequence is specified for character data in the Sort Order option Sequential order of character fields is tested against whatever sort The sort sequence for testing character data Invoice numbers could warrant further scrutiny. You could sort the invoice data for a particular vendor by date,Īnd then test the sequential order of the invoice numbers. Or check numbers, indicating possible irregularities. In data that should have an inherent sequential order, such as invoice Sequential order also allows you to identify out-of-sequence items Or sequentially order records requires performing separate sorting Sequentially ordered, and reports any errors of sequence. It verifies whether or not specified fields in a table are currently In any way modify the order of records in the table being tested. Sequential order does not sequentially order or sort records, or Testing sequential order does not sort records Testing for gaps is a different operation.
PAIRED SEQUENTIAL TESTING SERIES
For example, the numeric series (1, 3, 5) is sequentially ordered. Sequentially ordered data does not mean that the data has
0 kommentar(er)
