Hi pedro,

actually for table A I lookup on a date dimension table using a tmap with a filter condition like that: if (date_start>=date && date_end<=date)

but you're right, I should unite the two flows, but table A depend on what goes from table B (cause start date is the reference for minimum date of table B, as well as end date is reference for maximum date of table B)

Hi everybody,

I have something special (to me at least) to make in Talend: I have the impression that this is so to say a "recursive process" and I would like to have your opinion (and maybe a few leads).

I have 2 tables, let's say A and B

Content of A:
Batch Number | date_start    | date_end         | Station
XX                    | 2012-01-01 | 2012-01-28      | Station #1

Contents of B:
Batch Number | date_from    | date_to        | Station
XX                    | 2012-01-08 | 2012-01-20  | Station #2
XX                    | 2012-01-21 | 2012-01-28  | Station #1

What I would like to achieve is a "normalize" table with all days, station and Batch number. For example:
Batch Number | Date | Station
XX                    | 2012-01-01 | Station #1
...
XX                    | 2012-01-07 | Station #1
XX                    | 2012-01-08 | Station #2
...
XX                    | 2012-01-20 | Station #2
XX                    | 2012-01-21 | Station #1
...
XX                    | 2012-01-28 | Station #1

I already did with table A using a tmap and filter. But I'm stuck with how to include the second table. Any idea or experience with this kind of stuff ?

Thanks in advance for your support !