Auto Number - Data360_DQ+ - Latest

Data360 DQ+ Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 DQ+
Version
Latest
Language
English
Product name
Data360 DQ+
Title
Data360 DQ+ Help
Copyright
2024
First publish date
2016
ft:lastEdition
2024-07-09
ft:lastPublication
2024-07-09T15:09:58.774265

The Auto Number node is useful node allows you to give row numbers to a preexisting data set that does not have them.

Row numbering starts at 0.

  • Row Number Field Name - the name you want to give to the new field containing the row numbers.
  • Sort Order for Numbering - specify a field to sort by before numbering.

For example: Specifying row as the Row Number Field Name and state (Ascending) as the Sort Order for Numbering Field on the following data set,

state

city

measure

Illinois

Chicago

98

Arkansas

Little Rock

96

New York

Buffalo

95

Would result in the following numbered data set, sorted by state name in ascending order.

state

city

measure

row

Arkansas

Little Rock

96

0

Illinois

Chicago

98

1

New York

Buffalo

95

2

Tip: Auto Number can be particularly useful if you need to generate a unique id for each record in your data set.