You are not logged in.
Just add tAggregateRow to get the maximum and minimum date of table B.
Then use these two values to filter table A.
In the end, join the two flows with tUnite.
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)
I don't know how you did with table A.
But I think what you need is tUnite to combine two flows.
Or I misunderstand what you mean?
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 !