If you choose the Sequence type in a transform process and specify a field to group on, a new field of data will display in the result. You can sequence the original data by performing the following operations:

This operation collects the records in batches in numerical order, disregarding the groups.

The following table shows an example of the input and output (Start: 1, Count: 2):

Input | Output |
---|---|

A | 1 |

B | 1 |

A | 2 |

C | 2 |

B | 3 |

This operation creates a sequence according to the groups, disregarding the records.

The following table shows an example of the input and output (Start: 1, Step: 1):

Input | Output |
---|---|

A | 1 |

A | 1 |

B | 2 |

C | 3 |

C | 3 |

This operation creates a sequence according to the records, disregarding the groups.

The following table shows an example of the input and output (Start: 1, Step: 1):

Input | Output |
---|---|

A | 1 |

A | 2 |

B | 3 |

C | 4 |

C | 5 |

This operation creates a sequence according to the records from each group.

The following table shows an example of the input and output (Start: 1, Step: 1):

Input | Output |
---|---|

A | 1 |

A | 2 |

B | 1 |

C | 1 |

C | 2 |

This operation creates a round robin sequence according to the records, disregarding the groups.

The following table shows an example of the input and output (Start: 1, Count: 2):

Input | Output |
---|---|

A | 1 |

A | 2 |

B | 1 |

C | 1 |

C | 2 |