locked
Transformation logic in map RRS feed

  • Question

  • Hi All,

    in my map i am having requirement as follows :

    requirement is as follows :

    if TaxidNumber from schema1 should exist and not null and status should exist and not null then only create record in out out as Record - > status -> ABC of schema2 else don't generate this filed called Record in output.

    If TaxIdnumber field is exist and is not null then assign constant value = "Prodcut Error" to output message in HeadLine element.



    Thanks and Regards, Nitin.

    Friday, January 15, 2016 12:05 PM

Answers

  • Thanks all for help.

    that helped to me.


    Thanks and Regards, Nitin.

    • Marked as answer by Nitin Surya Friday, January 22, 2016 8:44 AM
    Friday, January 22, 2016 8:44 AM

All replies

  • Setup you links like this:

    TaxidNumber -> String Length Functoid -> Greater Then Functoid [0] -> Record

    That basically means if the value of TaxiNumber is not empty (and by implication exists) create the Record element.

    Friday, January 15, 2016 1:16 PM
    Moderator
  • Hi,

    here is the solution for this scenario.

    Regards,

    Muhammad Kamal

    Friday, January 15, 2016 3:27 PM
  • Hi Nitin,

    Thank you for posting on MSDN forum.

    You can create mapping something like below,

    TaxidNumber=>Scripting Functoid =>Equal Functoid=>

    AND Functoid

    Status=>Scripting Functoid=>Equal Functoid 

    Map it to Record. And your scripting functoid will check the value exist and not null. so it could be something like below,


    Thanks,

    If my reply is helpful please mark as Answer or vote as Helpful.

    My blog | Twitter | LinkedIn

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    Friday, January 15, 2016 10:54 PM
    Moderator
  • Thanks all for help.

    that helped to me.


    Thanks and Regards, Nitin.

    • Marked as answer by Nitin Surya Friday, January 22, 2016 8:44 AM
    Friday, January 22, 2016 8:44 AM