Use of function in mapping

[former_member75463]

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.

[Former Member · Accepted solution]

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

[prasannakrishna_mynam]

Qty  ------------------------                             
                                         | EqualsS(Text)| -- | IF | - Then -   Const('X') - |delete_ind| 
Constant(0.000) ---------                                          Else - Const(' ')- |delete_ind|

This will resolve your issue.

Regards,

Prasanna

[Former Member]

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

[Former Member]

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

[former_member187339]

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