How to generate a sequence with a tMap

[_AnonymousUser]

Hi everybody,
I read a lot of topic on this subject but I didn't suceed in what I wanted to do.
My goal is to generate a sequence for a delimited file.
For example, I have :
id_connexion, id_utilisateur, date_connexion,....
My delimited file is composed like this :
pierre;17/06/2008 11:11:15
jacques;17/06/2008 11:12:15
I'd like to generate a sequence to fill in the field id_connexion, this is what i'd like to have :
1;pierre;17/06/2008 11:11:15
2;jacques;17/06/2008 11:12:15
But not for a new delimited file but for a tOracleOutput. I've tried a lot of things, but I didn't find how to do.
My project is in java.
I have tOracleInput->tMap->tOracleOutput.
Could you please help me.
Thanks in advance.

[Anonymous]

Hello,
Create a variable in the Tmap with the folowing expression
Numeric.sequence("s1",1,1)
And link this variable to a new out column
JC

[_AnonymousUser]

I've already tried it but I have this message :
Starting job Int_Alim_Connexion at 11:54 17/06/2008.
null
null
null
Job Int_Alim_Connexion ended at 11:54 17/06/2008.
Do you know what could I do?

[Anonymous]

I've tried, it works good.
Sent an image of your Tmap

[Anonymous]

cool username!

[_AnonymousUser]

[_AnonymousUser]

How do you put a picture in the forum please?

[Anonymous]

you have to be registered and logged in.

[_AnonymousUser]

I don't succeed to put the picture, so could you please tell step by step how do you do to create the sequence and where do you put it.
Thanks in advance.

[Anonymous]

Here is sample tMap with Sequence Generator