Skip to Content
avatar image
Former Member

udf or graphical mapping

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

7 Answers

  • Best Answer
    Jul 21, 2015 at 07:09 AM

    Hi,

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

    Instead of ID in above mapping use MAT_NUM.


    Untitled.png (34.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2015 at 07:12 AM

    Hi Ram,

    Please try this

    Akhila.A


    mapping.jpg (34.5 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2015 at 08:14 AM

    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


    Fixvalue.png (6.1 kB)
    Map1.jpg (15.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2015 at 11:41 AM

    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..


    Capture.PNG (19.4 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2015 at 07:40 AM

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

    BR

    Satheesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2015 at 09:20 AM

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

    i am getting the following error..


    image (1).png (52.8 kB)
    image.png (41.7 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2015 at 09:47 AM

    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".

    Add comment
    10|10000 characters needed characters exceeded

    • 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.