Null Handling
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 16
- Joined: Wed Jan 30, 2008 3:22 am
Null Handling
Hi All
i have salary column , but few fields are null. If salary is null then i want 999 in the target otherwise i want the salary itself.
Ex:
Input:
ID|NAME|SALARY
101,RAY,10000
102,CHIRS,
103,RAM,20000
104,JESSY,
Output i want as :
ID|NAME|SALARY
101,RAY,10000
102,CHIRS,999
103,RAM,20000
104,JESSY,999
Thanks in advance.
i have salary column , but few fields are null. If salary is null then i want 999 in the target otherwise i want the salary itself.
Ex:
Input:
ID|NAME|SALARY
101,RAY,10000
102,CHIRS,
103,RAM,20000
104,JESSY,
Output i want as :
ID|NAME|SALARY
101,RAY,10000
102,CHIRS,999
103,RAM,20000
104,JESSY,999
Thanks in advance.
PRAKASH S G
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 16
- Joined: Wed Jan 30, 2008 3:22 am
Null Handling
Thanks for everybody. I know NullToValue in parallel but in server if i use IF THEN ELSE , I am not getting the desired value.. i am getting only null values in place of null values in the target. so please reply..
Thanks
Thanks
PRAKASH S G
-
- Participant
- Posts: 16
- Joined: Wed Jan 30, 2008 3:22 am
-
- Participant
- Posts: 16
- Joined: Wed Jan 30, 2008 3:22 am
Chulett,
Thanks for your quick reply and i have mentioned as you are said , but still i am not getting solution for this.
If IsNull(a.SALARY) then 999 else a.SALARY.
Here is the a is the source link.
if i put this condition , i am not getting 999 in the place of null, i am getting only null in the null place.
So please reply for the same..
Thanks
Thanks for your quick reply and i have mentioned as you are said , but still i am not getting solution for this.
If IsNull(a.SALARY) then 999 else a.SALARY.
Here is the a is the source link.
if i put this condition , i am not getting 999 in the place of null, i am getting only null in the null place.
So please reply for the same..
Thanks
Last edited by Prakash3366 on Tue Jul 28, 2009 10:50 am, edited 1 time in total.
PRAKASH S G
-
- Participant
- Posts: 16
- Joined: Wed Jan 30, 2008 3:22 am
chulett,
I want to explain the job.
my source has three columns. ID, Name and salary.
the datatype of these columns is integer, varchar and integer respectively.
i checked option, Nullable is Yes for salary column. But still i am not getting desired result.
can you help me about this.
Thanks
I want to explain the job.
my source has three columns. ID, Name and salary.
the datatype of these columns is integer, varchar and integer respectively.
i checked option, Nullable is Yes for salary column. But still i am not getting desired result.
can you help me about this.
Thanks
PRAKASH S G
-
- Participant
- Posts: 16
- Joined: Wed Jan 30, 2008 3:22 am
-
- Participant
- Posts: 16
- Joined: Wed Jan 30, 2008 3:22 am