topic Re: Reset Sequence in Components in Data Quality

Reset Sequence in Components

Anonymous — Sat, 16 Nov 2024 09:20:25 GMT

Hi All

I want to reset the sequence based on the Column ID .here is the eg Input

Numer,sequence("S1",1,1) this wont give my result

Numeric.resetSequence("S1",1) this is not giving a result what i want.

Let me know what should i do or any solutions

ID,Amount

100,1000

100,2000

200,3000

200,4000,

200,5000

300,6000

Output i need

ID,Amount,ResetSeq

100,1000,1

100,2000,2

200,3000,1

200,4000,2

200,5000,3

300,6000,1

Re: Reset Sequence in Components

Anonymous — Sun, 03 Sep 2017 21:35:29 GMT

Use below, it will solve your problem.

Numer,sequence(input_row.ID,1,1)

Please accept solution if it works

Re: Reset Sequence in Components

TRF — Sun, 03 Sep 2017 21:39:18 GMT

Hi,

The sequence name must be based on the id value.

This can be done by a tJavaRow with the following code:

if (input_row.id != ((Integer)globalMap.get("id")) && ((Integer)globalMap.get("id")) != null) {
	// Id change, remove previous sequence and memorize current id
	Numeric.removeSequence(Integer.toString((Integer)globalMap.get("id")));
	globalMap.put("id", input_row.id);
}

output_row.id = input_row.id;
output_row.amount = input_row.amount;
// Initialize or get next value from current sequence 
output_row.sequence = Numeric.sequence(Integer.toString(input_row.id), 1, 1);

Each time the id change, the current sequence is removed and a new one is created.

According to your data sample, here is the result:

Starting job test at 22:34 03/09/2017.

[statistics] connecting to socket on port 3683
[statistics] connected
100|1000|1
100|2000|2
200|3000|1
200|4000|2
200|5000|3
300|6000|1
[statistics] disconnected
Job test ended at 22:34 03/09/2017. [exit code=0]

Note that all fields are defined as integers.

Hope this helps.

Re: Reset Sequence in Components

TRF — Mon, 04 Sep 2017 16:45:18 GMT

Did it help you?

Re: Reset Sequence in Components

Anonymous — Tue, 12 Sep 2017 13:00:11 GMT

Hi
Do we have any other options other than tJavaRow

Re: Reset Sequence in Components

TRF — Tue, 12 Sep 2017 13:11:16 GMT

Probably you can do it using tMap but it may be a little confusing. tJavaRow is the best solution from my point of view. Any problem with this idea?

Re: Reset Sequence in Components

Anonymous — Tue, 12 Sep 2017 13:14:12 GMT

Problem is not with the solution ..I read it some where like dont use tJavarow .until unless if its a last option..it will slow down the job like that...

Re: Reset Sequence in Components

TRF — Tue, 12 Sep 2017 13:16:17 GMT

Maybe if you are looking for microseconds, else you can go on.

Re: Reset Sequence in Components

Reims — Tue, 23 Jun 2020 15:01:33 GMT

Hello TRF,

please can you tell me where you initialize the id global variable?

cause by my side, i got a null pointer exception, and i think it is related to this variable.