DSXchange

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

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.

vinsashi wrote: 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...!

Thanks to All