Skip to main content
Question

How to generate row numbers

  • August 25, 2022
  • 1 reply
  • 78 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

Pradeep
StreamSets Employee
Forum|alt.badge.img+1
  • StreamSets Employee
  • 48 replies
  • August 25, 2022

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