Hi Guys
I have to do a some sort of validation process in the datastage transformer. The logic to be used is=>
If the input value for one particular column is not "Numeric" then don't move it to the next level or stage. The data which is Numeric is only moved further. I am reading the Data as Varchar. Can anyone suggest what logic I use to produce this kind of output using the constraint of transformer.
Thanks
Transformer logic
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 73
- Joined: Tue May 10, 2005 6:21 pm
- Location: Sydney
Re: Transformer logic
The function IsValid can be used to check if a value is numeric, I am using Transformer stage variable to keep the result and then it can be used in the constraint condition.
kashif007 wrote:Hi Guys
I have to do a some sort of validation process in the datastage transformer. The logic to be used is=>
If the input value for one particular column is not "Numeric" then don't move it to the next level or stage. The data which is Numeric is only moved further. I am reading the Data as Varchar. Can anyone suggest what logic I use to produce this kind of output using the constraint of transformer.
Thanks
Edward Yuan
-
- Participant
- Posts: 48
- Joined: Wed Jun 01, 2005 7:10 am
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
-
- Participant
- Posts: 20
- Joined: Tue Jun 13, 2006 5:16 am
- Location: Pune