Hello
Thanks for these answers.
I think you need more precision for my problem.
In fact, there is not always 3 rows for each key (A, B ... etc). I realize that my example was not complete.
I can have :
A 0
A 1
A 2
B 1
B 5
B 12
B 15
C 6
and the output would be :
A 0
A 1
A 2
A 15
B 0
B 1
B 5
B 12
B 15
C 0
C 6
C 15
the lines "A 15", "B 0", "C 0" and "C 15" has been added.
Indeed, i need to add the row with the zero but also the end of the interval if it doesn't exist (the end of the interval is known and it is always the same : in my example it's 15)
So you can see that :
1- I don't know how many lines there will be for each key, so i think i can't unfortunately use the solution with tNormalizer suggested by psm2000 (sean)
2- I want to fill several holes but 2 maximum (the start 0 and the end 15) : i didn't said it first because i thought it was the same problem that for the 0. so i don't want to fill all the holes.
asethi, i am not sure to understand what you want me to do : could you precise your idea ? which component must I use for the outer join ? and where do you define that the null value will be UNDEFINED ?
sorry, but i'm a starter with Talend.
Thanks.