topic Re: [resolved] Inserting row number dynamically in Talend Studio

[resolved] Inserting row number dynamically

Anonymous — Thu, 09 Oct 2014 06:43:35 GMT

Hi,
I have an XML file from which I extract the fields using tXMLMap component.
Along with these field values I have to insert a row number for each row inserted.
Any idea how this can be done?

Re: [resolved] Inserting row number dynamically

Anonymous — Thu, 09 Oct 2014 09:32:57 GMT

How about using function for generating sequence ?
Vaibhav

Re: [resolved] Inserting row number dynamically

Anonymous — Thu, 09 Oct 2014 09:57:15 GMT

How about using function for generating sequence ?
Vaibhav

Do you mean I should create an SQL function for this? Is it not possible through Talend?

Re: [resolved] Inserting row number dynamically

Anonymous — Thu, 09 Oct 2014 10:26:11 GMT

Ketan,
You can use Numeric.sequence expression in your tMap to increment a variable.
For exemple : Numeric.sequence("var1",1,1)
The second "1" is the starting number, the last "1" is to increment by 1, and the new value is saved into "var1".
Devy

Re: [resolved] Inserting row number dynamically

Anonymous — Wed, 16 Oct 2019 13:27:05 GMT

https://faihofu.blogspot.com/2019/10/talend-rownumber-functionality-using.html
is this blog post any use?

it uses tMap to mimic the tsql row_number() over (partition by....) windows function