Page 1 of 1
Bad Data ???
Posted: Tue May 11, 2010 6:50 am
by karthi_gana
All,
I have a file which will be uploaded into a table.
say for example
Eno char 5
DOB datetime
Salary decimal 18,6
1
01/01/1970
12000
Incase if i have bad data like
2
M -- Should be datetime
A -- Should be decimal
I have to check the above and need to reject this row.
How?
Inputs are welcome!
Posted: Tue May 11, 2010 7:05 am
by chulett
Server has several functions that could help with this, check out Num() (etc) or find Ray's free Server version of the PX IsValid() function.
Posted: Tue May 11, 2010 7:19 am
by karthi_gana
chulett wrote:Server has several functions that could help with this, check out Num() (etc) or find Ray's free Server version of the PX IsValid() function. ...
i tried like
not(num(salary)) in the transofrmer...
but no use...
it is not rejecting the rows...
Posted: Tue May 11, 2010 8:42 am
by nagarjuna
In a parallel job , sequential file automatically rejects . Put a reject link and collect records which are having bad data .
Posted: Tue May 11, 2010 9:01 am
by Sainath.Srinivasan
Maybe you need to say what you have tried including stage, variables, constraints and sample data.
Posted: Tue May 11, 2010 9:29 am
by chulett
nagarjuna wrote:In a parallel job , sequential file automatically rejects . Put a reject link and collect records which are having bad data .
How is that going to help someone with a Server job?
Posted: Tue May 11, 2010 4:35 pm
by ray.wurlod
karthi_gana wrote: i tried like
not(num(salary)) in the transofrmer...
but no use...
it is not rejecting the rows...
Show us the precise constraint expressions you are using.