week id misiing

[vinsashi]

Hi,
in source data i have two fileds
weekid value
1 10
2 20
3 30
4 40
5 50
in some times i will get data like this in source some weekids wil miss
weekid value
1 10
3 30
4 40
5 50
so in output i need like this
weekid value
1 10
2 0
3 30
4 40
5 50

[ray.wurlod]

Join to a generated data stream containing 1, 2, 3, 4, 5. Use a left outer join, with the generated data being the left input. Convert the null to a zero.

[gssr]

so in output i need like this
weekid value
1 10
2 0
3 30
4 40
5 50

Get all the WeekId into a dataset and use Full Outer join with your Source file to get the desired Output...!

[vinsashi]

Thanks to All