on 09-10-2009 9:08 AM
Hello,
I need to put this logic in PI mapping.
If Qty = '0.000', then pass 'X' to delete_ind else pass ' ' to delete_ind.
How do I implement this? I had used equalA & ifelse function but it does not work.
If Qty = '0.000', then pass 'X' to delete_ind else pass ' ' to delete_ind.
constant[X]---> then
Qty--------------->equalS------->if---->delete_ind (Target Field)
constant[0.000]/ constant[ ]---> else
'map constant0.000 to equalS
constant[ ] to else
choose if from function category Boolean
equalS from function category Text
Edited by: Kubra fatima on Sep 10, 2009 10:25 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Qty ------------------------
| EqualsS(Text)| -- | IF | - Then - Const('X') - |delete_ind|
Constant(0.000) --------- Else - Const(' ')- |delete_ind|
This will resolve your issue.
Regards,
Prasanna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes you can also use FixValues standard function present under the function category Conversions
Qty---->FixValues---->delete_ind
double click on FixValues to provide key and Value
Key Value
0.000 X
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
you can use Fix Value Mapping, which is a standard function.
Conver 0.000 to X and set default value ans blank in case there is no match.
Regards,
Vikas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Use like this
Qty
\
\ equalsA (Text equals) -- if then Constant 'X' -- delete_ind
'0.000', / else Constant ' '
Regards
Suraj
Edited by: S.R.Suraj on Sep 10, 2009 4:13 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.