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
week id misiing
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: week id misiing
Get all the WeekId into a dataset and use Full Outer join with your Source file to get the desired Output...!vinsashi wrote: so in output i need like this
weekid value
1 10
2 0
3 30
4 40
5 50
RAJ