Question

How to generate row numbers

  • 25 August 2022
  • 1 reply
  • 59 views

Hi team,

Need to create rank/row number function for each row just like how we do in SQL.

How to implement using expression evaluator/groovy etc.

can anyone  please help me with this .


1 reply

Userlevel 3
Badge +1

Hi @vasanthi , SDC processes data at batch level. If you are expecting to implement rank (or) rownumber functionality for the complete input data you would want to use “Rank” processor by creating a pipeline in Streamsets Transformer.

Reply