topic Re: How to generate a sequence with a tMap in Talend Studio

How to generate a sequence with a tMap

_AnonymousUser — Sat, 16 Nov 2024 14:20:06 GMT

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.

Re: How to generate a sequence with a tMap

Anonymous — Tue, 17 Jun 2008 10:46:57 GMT

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

Re: How to generate a sequence with a tMap

_AnonymousUser — Tue, 17 Jun 2008 10:56:27 GMT

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?

Re: How to generate a sequence with a tMap

Anonymous — Tue, 17 Jun 2008 11:04:26 GMT

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

Re: How to generate a sequence with a tMap

Anonymous — Tue, 17 Jun 2008 11:38:21 GMT

cool username!

Re: How to generate a sequence with a tMap

_AnonymousUser — Tue, 17 Jun 2008 12:50:07 GMT

Re: How to generate a sequence with a tMap

_AnonymousUser — Tue, 17 Jun 2008 12:50:53 GMT

How do you put a picture in the forum please?

Re: How to generate a sequence with a tMap

Anonymous — Tue, 17 Jun 2008 13:02:52 GMT

you have to be registered and logged in.

Re: How to generate a sequence with a tMap

_AnonymousUser — Tue, 17 Jun 2008 13:17:55 GMT

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.

Re: How to generate a sequence with a tMap

Anonymous — Wed, 18 Jun 2008 07:26:23 GMT

Here is sample tMap with Sequence Generator

Re: How to generate a sequence with a tMap

_AnonymousUser — Wed, 18 Jun 2008 10:38:27 GMT

Thanks for your mapping but I don't understand why do you have 2 primary keys.
In my mapping, I have my delimited file on the left, my sequence in the "var" part (on the middle), and on the right side, my destination table. My sequence is link to the primary key of my destination table.
I still have an error, he doesn't want to raise my sequence because he always returns "null".
Do you have an idea please?
I use a FileDelimited->tMap->tOracleOutput and not tOracleInput->tMap->tOracleoutput like I said. I was wrong, sorry.
Thanks in advance for your answer.

Re: How to generate a sequence with a tMap

Anonymous — Wed, 18 Jun 2008 20:09:21 GMT

In the Ecosystem, I saw a tAddSequence component -

Re: How to generate a sequence with a tMap

Anonymous — Thu, 19 Jun 2008 07:19:21 GMT

Hi Megadeth2,
I just modified the existing job to show the sequence. We do not need to have two primary keys. Its an example.
-
sangi

Re: How to generate a sequence with a tMap

Anonymous — Thu, 19 Jun 2008 07:34:14 GMT

Hi Megadeth2,
I just designed the job for sequence generator.
Here I am attaching the job and tMap.
This is my tsv file:
Organization City
Yahoo CA
Google NY
AOL NJ
Database MySQL:
1,Yahoo,CA
2,Google,NY
3,AOL,NJ

Var Expression:
Numeric.sequence("s1",1,1)

please upload images of your job if you still face any problem.
regards,
sangi

Re: How to generate a sequence with a tMap

_AnonymousUser — Thu, 19 Jun 2008 08:44:11 GMT

Hi Sangui,
Thanks for your answer, I did the same you show me but I still have the problem "null", I don't understand why he doesn't want to raise my sequence.
I can't upload images, so I'll keep on searching what is the problem.
Thanks a lot for yours advices.

Re: How to generate a sequence with a tMap

Anonymous — Thu, 19 Jun 2008 10:06:34 GMT

I think it's a problem with my destination table because I do the same thing with an other job and it's ok.

Re: How to generate a sequence with a tMap

Anonymous — Fri, 20 Jun 2008 06:32:26 GMT

are you able to generate the sequence?

Re: How to generate a sequence with a tMap

_AnonymousUser — Fri, 20 Jun 2008 09:05:37 GMT

My problem was my destination table because I did the same thing with an other job and it was ok. Now it's ok.
Thanks a lot for your help.

Re: How to generate a sequence with a tMap

_AnonymousUser — Wed, 15 Mar 2017 08:43:32 GMT

Hi all,can any body explain how to generate cyclic sequence values in talend bigdata.
EX
col1 col2
A 1
A 2
A 3
B 2
B 2

Re: How to generate a sequence with a tMap

_AnonymousUser — Wed, 15 Mar 2017 08:45:17 GMT

Hi all,can any body explain how to generate cyclic sequence values in talend bigdata.
EX
col1 col2
A 1
A 2
A 3
B 1
B 2