1. Component library
  2. Transform
  3. Numbers
  4. Generate ID

Generate ID

Generates a unique and sequential record ID

Transformer Concurrent Distributed execution possible

Configured properties

  • Column in scope

    A column which represent the scope for which the ID will be generated. If eg. a source column is selected, an ID will be generated for each source record. If a transformed column is selected, an ID will be generated for each record generated that has this column.

    InputColumn<Object> Required

  • Id type

    A type of ID which will be generated for each record in scope. Current options: sequential numbers or row number.

    Choice: Sequence Row number Required

  • Offset

    The row number offset. This is often used to insert into a database with existing sequential IDs. Since the transformer increments before inserting, an offset of e.g. 100 would make the first newly inserted ID 101.

    long Required