Solved: [resolved] Inserting row number dynamically - Qlik Community

Anonymous · ‎2014-10-09

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?

Anonymous · ‎2014-10-09

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

View solution in original post

Anonymous · ‎2014-10-09

How about using function for generating sequence ?
Vaibhav

Anonymous · ‎2014-10-09

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?

Anonymous · ‎2014-10-09

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

Anonymous · ‎2019-10-16

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

[resolved] Inserting row number dynamically

Talend Data Integration

v5.x

XML