This plugin provide PDI step that adds a sequence value which resets or increment each time a value changes in the list of specified fields.
Pentaho Data Integration 8.0 or above
- Find the plugin in the Pentaho Marketplace and click Install
- Restart Spoon
- Place the “pdi-combinationsequence-plugin” folder in the ${DI_HOME}/plugins/ directory
- Restart Spoon
Sequence mode example
| Field1 | Field2 | RESET | INCREMENT |
|---|---|---|---|
| A | B | 1 | 1 |
| A | B | 2 | 1 |
| A | B | 3 | 1 |
| A | C | 1 | 2 |
| C | C | 1 | 3 |
| C | C | 2 | 3 |
| D | C | 1 | 4 |
This plugin for PDI is provided “as is”, without any warranties, expressed or implied. This software is not covered by any Support Agreement.
Licensed under the Apache License, Version 2.0.