topic [Help] Sequence Number from different file in Talend Studio

[Help] Sequence Number from different file

Anonymous — Tue, 17 Nov 2015 04:01:28 GMT

Re: [Help] Sequence Number from different file

Anonymous — Tue, 17 Nov 2015 10:27:29 GMT

Hi
You need to set a different sequence name for each file instead of a constant "s1", if you are using tFileList to iterate each file, you can set the sequence name with the global variable which counts the current file, for example:
Numeric.sequence(((String)globalMap.get("tFileList_1_CURRENT_FILE")),1,1)

Re: [Help] Sequence Number from different file

Anonymous — Tue, 17 Nov 2015 10:46:40 GMT

2 sequences won't work for this I don't think Shong. It looks like thy want to tie the number to the code in both files. So if code 103 is awarded a 1 in one file, it will also have a 1 in the other file. The easiest way I can think of doing this is to do the following....

1) Create a routine.
2) Create a HashMap and an integer to keep track of the sequence in the routine.
3) For each code that is sent to the routine, check the HashMap to see if it exists. If it does not, add 1 to the sequence and store the current value of the sequence in the HashMap using the code as the key to the value. If it does exist, use the code to retrieve the value stored.
This will return the same sequence values between the files if the codes are the same.

Re: [Help] Sequence Number from different file

Anonymous — Tue, 17 Nov 2015 13:29:58 GMT

No 103 gets 3. 104 gets 4. The sequence is based on the code field - 100.

Re: [Help] Sequence Number from different file

Anonymous — Tue, 17 Nov 2015 14:56:51 GMT

I took it that that was a oversight of the example JanHess2. If not, then simply subtracting 100 would do.

Re: [Help] Sequence Number from different file

Anonymous — Wed, 18 Nov 2015 02:11:26 GMT

Hi shong i think it doesnt work, second sequence can start again from "1". I want sequence number based on the first sequence.

for rhall_2.0, can you give me an example code in routines? thank you for your reply

Re: [Help] Sequence Number from different file

Anonymous — Wed, 18 Nov 2015 02:37:59 GMT

Hi erbi
Sorry, I read your question so quickly before, I think i understand your request know, as rhall_2.0 suggested, you need to hard code in a routine to return the sequence id based on the code field.

Re: [Help] Sequence Number from different file

Anonymous — Wed, 18 Nov 2015 08:58:46 GMT

Hello,
As rhall_2.0 said , you can create a routine.
An example of routine can be this one I think :

package routines;

import java.util.HashMap;
import java.util.Map;

public class Sequences {
	public static Map<Integer,Integer> map = new HashMap<Integer, Integer>();
	public static Integer value = 0;
	
    public static Integer getId(Integer code) {
        if (! map.containsKey(code)){
        	value = value +1;
        	map.put(code, value);
        }
        return map.get(code);
    }
}

When your routine had been created just call it in your tMap (the call is in this case : Sequences.getId(row1.code) )
I hope it will help you.

Re: [Help] Sequence Number from different file

Anonymous — Wed, 18 Nov 2015 09:09:03 GMT

Yeah, that would do it tdz (.......damn it, you got there first! )

Re: [Help] Sequence Number from different file

Anonymous — Wed, 18 Nov 2015 09:26:44 GMT

rhall_2.0 wrote:
Yeah, that would do it tdz (.......damn it, you got there first! )

Thank you and sorry rhall_2.0, next time I will let you give the solution first (moreover because it's your idea)

Re: [Help] Sequence Number from different file

Anonymous — Tue, 24 Nov 2015 06:29:32 GMT

hei tdz and rhall, in Sequences.getId(row1.code), row1.code can replace by what? thank you

Re: [Help] Sequence Number from different file

Anonymous — Tue, 24 Nov 2015 09:22:37 GMT

"row1.code" should be replaced by whatever you want to be the key to your sequence number.