udf or graphical mapping

[Former Member]

Hi,

I needaudfor graphical mapping for the following condition.

If MAT_NUM exist... ----------> theMAT_NUM value should reflect in target field ITEM_CODE,

elseMAT_NUM= SCHEME---->this should reflect as "A" in ITEM_CODE

elseMAT_NUM= VAS------------>this should reflect as "B" in ITEM_CODE

[sahithi_moparthi · Accepted solution]

Hi,

You can use graphical mapping.Please find the mapping below:

Instead of ID in above mapping use MAT_NUM.

[Former Member]

Hi,

Thanks all its working..but there is an another requirement i.e

if CRE_DAT= exist then it should reflect in GIDate

else CRE_DAT=00000000 then it should reflect as Current_Date

else CRE_DAT is not available, it should reflect as Current_Date..

So, i have developed a mapping in such a way as when CRE_DAT=00000000 then it should reflect as Current_Date else CRE_DAT,,could any one improve my logic with the above requirement..It would be more helpful..

[sahithi_moparthi]

Hi,

Use the Logic as below:

If CRE_DAT exist and CRE_DAT = 0000000 then pass current date

In else condition pass Current date.

[Former Member]

Hi Sahithi,

The condition is not like the below:-

"If CRE_DAT exist and CRE_DAT = 0000000 then pass current date, else condition pass Current date."

It is:-

Some times if CRE_DAT exist then it should reflect in GIDate.( at this time, CRE_DAT will not be "00000000"..)

If value of CRE_DAT="00000000" comes, it should reflect as CurrentDate..(at this time , CRE_DAT will not exist)

If value of CRE_DAT doesnt come it should reflect as CurrentDate(at this time , CRE_DAT will not exist and CRE_DAT will not be "00000000")

pfa in which i followed, but its showing the same error..

[sahithi_moparthi]

Hi Mohan,

   The logic is same as MAT_NUM,instead of MAT_NUM use CRE_DATE.There is no difference in logic.

Apply the same and let me know if still persists.

If CRE_DATE exist then pass same value as CRE_DATE

else  if C CRE_DATE =0000000 then pass CurrentDate

else pass Current date

Please let me know if you still faces issue.

[Former Member]

Hi Sahithi,

The answer for the above requirement is this..

[sahithi_moparthi]

Hi,

If issue resolves please close the thread.

[Former Member]

Actually, in the above screenshot which i have shared..if the MAT_NUM = "SCHEME" or "VAS", doesnt have DeliveryOrderNo.. Here DeliveryOrderNo is a primary key.

Could any one plz suggest me that the When if the MAT_NUM = "SCHEME" or "VAS", there will not be any DeliveryOrderNo.

So, what changes could be made that values should pass as "X" in DeliveryOrderNo when the values coming for MAT_NUM = "SCHEME" or "VAS".

[Former Member]

Hi Ram mohan,

Please just follow my logic mentioned above and add additional condition in fix value mapping.

I hope you get expect result.

Thank you.
Sateesh

[sahithi_moparthi]

As per your above statement,i understood that DeliveryOrderNo is another field.Use the logic as:

If  MAT_NUM = "SCHEME" or "VAS" then pass "X" value in DeliveryOrderNo.

It seems you are facing issue with ItemCode and DeliveryOrderNo.

Please test both the fields using above logic and let us know if still issue persists.

[Former Member]

when i am using the above mapping logic given by akhila,

i am getting the following error..

[sahithi_moparthi]

Hi,

Try to change the context of matnumber in mapping.

[Former Member]

Hi Ram mohan,

May be this is simple way according your requirement.

Please just try.

In this example I use source field as 'username' and target field ' Firstname'

Fix value mapping:

In the fix value you must enable "use key" radio button

Thank you.

Sateesh

[Former Member]

Sahithi's answer should work and its a straight forward one.

BR

Satheesh

[Former Member]

Hi Ram,

Please try this

Akhila.A