Work with Numeric.sequence()

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

Hello,

I can't find a solution for a problem I have. I have tried many things in the tMap, but without success. I show you the goal and what I want to achieve with an example.

First, I need a column "HIST_INDICATOR" that when a date is found for the first time in the dataset, the indicator is 0, then 1 for the next times (or if the date already exists in the database). This condition applies only to rows of type "070" because these are the ones that will be integrated into a table in the database. There are 3 types (070, 223 and 255 because the other types will be integrated in another table). Here is my data set (reduced for the example) :

Here is what I use in tMap to answer my first need

Here is what I get, and if I filter by "070", I have the desired indicator

However, I can't get the 070 indicator to follow for the other lines (until the next 070), here is what I would like to get

Re: Work with Numeric.sequence()

Jfoster1657625676 — Fri, 30 Dec 2022 09:06:16 GMT

A number sequence is a list of numbers that are linked by a rule. If you work out the rule, you can work out the next numbers in the sequence.

topic Re: Work with Numeric.sequence() in Talend Studio

Work with Numeric.sequence()

Re: Work with Numeric.sequence()