Working with sequences

stephbzr — Fri, 15 Nov 2024 22:15:26 GMT

Hello,

Here is what I needed to do in a previous task : for each row where the entity is 070 (because these rows are stored in a different table from the others), put 0 when the date (column REP_DATRO) is found for the first time otherwise 1.

Here is the code to have the HIST_INDICATOR column :

Here is what I want to do now in a new column :

It's quite difficult, I don't have a deep knowledge of existing methods in JAVA to help me accomplish this. Here is what I have tried so far

Re: Working with sequences

Anonymous — Thu, 22 Dec 2022 02:52:58 GMT

I don't understand why the HIST_INDICATOR column has empty value in your second image, with the expression shown in the first image, there should be 1 or 0?

Regards

Shong

topic Working with sequences in Talend Studio

Working with sequences

Re: Working with sequences