tMap - How do i know if I am on the last row?

Anonymous — Sat, 24 Sep 2016 01:44:27 GMT

I need to know if I am on the last row in a tmap to perform logic. Is there an flag any where that I can use? I was thinking of counting the rows in the file before the tMap and maintain a counter within.

Re: tMap - How do i know if I am on the last row?

Anonymous — Sat, 24 Sep 2016 04:51:18 GMT

Hi
No a direct way to know it, you can count the rows first, and then add a sequence id to each row in the next subjob, for example:
tfileinputDelimited1--main---tJavaRow
|
onsubjobok
|
tfileinputDelimited2--main--tMap-->

there is a global variable defined on tfileinputdelimited1 to store the total number of rows are read from the file:
((Integer)globalMap.get("tFileInputDelimited_1_NB_LINE"))

on tMap: add a new column as row number, set its expression as: Numeric.sequence("s1",1,1)

Regard
Shong

topic tMap - How do i know if I am on the last row? in Talend Studio

tMap - How do i know if I am on the last row?

Re: tMap - How do i know if I am on the last row?