graphical mapping problem

[Former Member]

Hi ,

I am doing a graphical mapping

fields on the outbound side are SL_ITEM_TYPE, SL_ITEM_ID and IV_ITEM_ID

if the input field on

SL_ITEM_TYPE is INV then SL_ITEM_ID shd be null and IV_ITEM_ID shd have value

and when SL_ITEM_TYPE is MNU IV_ITEM_ID shd be null and SL_ITEM_ID shd have value

On the inbound side one field MATERIAL has to be mapped to IV_ITEM_ID or SL_ITEM_ID , if SL_ITEM_TYPE is INV vlue shd be picked from IV_ITEM_ID and if SL_ITEM_TYPE is MNU value shd be picked from SL_ITEM_ID and mapped to MATERIAL field.

pl help on this ..

ans will be rewarded

rgds

mojib

[Former Member]

Hi,

Do it this way.

SL_ITEM_TYPE

equals(from strign ops) if

Constant(Value INV)

then IV_ITEM_ID -> material

else

SL_item_type

equals (from strign ops) if <withoutelse> -> SL_ITEM_ID ->material.

cosntant(value MNV)

Thanks,

Vijaya.

[Former Member]

Hey check this.

http://picasaweb.google.co.uk/domakuntla.srinivas/UntitledAlbum/photo#5204970967034578514

Thanks,

Vijaya.

[Former Member]

1)if (SL_ITEM_TYPE) == 'INV'

then

SL_ITEM_ID link to a constant with length zero

length of(IV_ITEM_ID) > 1

you have given it as some data for IV_ITEM_ID......

2) SL_ITEM_TYPE == 'MNU'

then

IV_ITEM_ID link to a constant with length zero

SL_ITEM_ID shd have value

For inbound side use the IF else logic....

<b>*************Reward points,if found useful</b>

[aashish_sinha]

Hi,

Try your logic in this way to acehive your goal. Use If without else and If as i suggested in this psedo code.

Try to do exactly like this in graphical mapping. If you find any problem you can write the same logic in UDF also.

IV_ITEM_ID=MATERIAL;

SL_ITEM_ID =MATERIAL;

if (SL_ITEM_TYPE == "INV"

IV_ITEM_ID ; // mAP TO MATERIAL id

if SL_ITEM_TYPE == "MNU"

SL_ITEM_ID ; mAP TO Material.

If (SL_ITEM_TYPE == INV) then

SL_ITEM_ID ="";

IV_ITEM_ID ="This is what i want";

else

if (SL_ITEM_TYPE == MNU) then

IV_ITEM_ID = "" ;

SL_ITEM_ID = "This is what i want";

Regards

Aashish Sinha

PS : reward points if helpful

[Former Member]

Hi

i tried using "ifwithout else" but could not , can u send me some screen shot for this mapping, if possible

rgds

mojib