I want only one value on target side. but dummy values are showing. how to hide dummy fields

[Former Member]

Hi XI/PI Exports,

If Source (E1EDP - BETRG) value is not Zero, then Target (E1EDP) must appear.

Here dummy values are showing on target side. so how to hide that dummy values. I want only one E1EDP value on Target side. remaining all not appear. what is the solution

Thanks

Soma

[Former Member]

Hello Soma,

Try using mapping as below:

but just keep the context good.

[praveen_sutra]

hi Soma,

You need to handle  the context appropriately.

For better understanding could you please share screenshot  of  your mapping,  source and target structure.

thanks and regards,

Praveen T

[Former Member]

Hi Praveen,

Thanks for your replay. please find the below screen shot.

Target field E1EDP01(I want only one time but it is showing dummy fields also. so how to change this screen shot)

let me inform me.

Thanks

Soma

[praveen_sutra]

Hi soma,

we would still require source structure..

with this info please try this.

BETRG equals [0] -> [NOT] -> [sort] -> [collapse context] -> [if then] -> [E1EDP01- SPRILT by value] -> E1EDP01

thanks and regards,

Praveen t

[former_member182412]

Hi Soma,

BETRG field is currency field so the default value for this field is '0.00' not '0'.

So please use below mapping to solve your problem. My screen shot the target is Item but your case it is E1EDP.

Regards,

Praveen.

[Former Member]

Hi Praveen,

Thanks for your replay. please find the below screen shot.

let me check and conform

BETRG == 0 If then E1EDP01 (appear only single time and hide dummy fields)

BETRG NotEqual Zero (means either 1 r decimal no 1.1121) If Then  must appear.

above screen shot

1. equal zero time not appear 

2. not equal time it is appear.

please send me reply

Thanks

Soma

[Former Member]

Hi Praveen,

Thanks for your reply.

BETRG == 0 If then E1EDP01 (appear only single time and hide dummy fields)

BETRG NotEqual Zero (means either 1 r decimal no 1.1121) If Then  must appear.

above screen shot

1. equal zero time not appear 

2. not equal time it is appear.

please send me reply

Thanks

Soma

[former_member182412]

Hi Soma,

Can you paste the source and target payloads for both cases if BETRG equals to zero and not zero. not complete playload just E1EDP01 part of the payload for both source side and target side then we can understand more clearly what you need.

Regards,

Praveen.

[Former Member]

Hi Praveen,

1. If (Source)E1EDP26-BETRG value is not Zero, then (Target)E1EDP01 must appear
[E1EDP01 to E1EDP01]

2. If E1EDP26-BETRG value is Zero, then E1EDP01 appear only ones(not appear dummy fields) [E1EDP01 to E1EDP01]

Thanks

Soma