how to get last value in each row
Moderators: chulett, rschirm, roy
Hi,
In the output derivation:
Transformer has to run in sequential mode.
Thanks,
Chetan.C
In the output derivation:
Code: Select all
field(DSLink2.val,"_", @INROWNUM)
Thanks,
Chetan.C
I seriously doubt that example actually represents the incoming data such that you can assume the last field will always match the row number. A generic answer would be to count() the delimiters and pull the "count+1" field from the "_" delimited string.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
Field(InLink.TheString, delimiter, Count(InLink.TheString, delimiter) + 1, 1)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
Field(InLink.TheString, delimiter, Count(InLink.TheString, delimiter) + 1, 1)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.