Automate

 View Only

  • 1.  Transform Rules

    Posted 03-05-2020 07:26
    Hi all,

    I am new here so please be gentle!! :-)

    I am trying to write some transform rules and wondered if there is a resource such as a dictionary that will give a list of statements available and their associated syntax.

    At present I am trying to do a if "If xx is null, then, else" type statement and am struggling! These statements are all so different in Excel, Access and SQL so be nice to know what WinShuttle likes to avoid too much trial and error.

    Thanks in advance.

    Andy.

    ------------------------------
    Andy Reid | Data Migration Consultant
    AstraZeneca plc |andrew.reid1@astrazeneca.com
    ------------------------------


  • 2.  RE: Transform Rules

    Employee
    Posted 03-12-2020 10:15
    Hi Andy

    We only support transforms with Excel, so just about any formula you can use in Excel you can use in a script.  There are a bunch of sites that can help you with Excel formulas.  

    For IF's, you would do something like:  =if(A2="","I am blank","I am not blank")
    Assuming you data is in column A, you data starts on row 2 (it will apply it for each row of data so you just need a start row number).  If TRUE, then you'll get "I am blank".  If FALSE, you'll get "I am not blank".   Map the formula output to another column to create a new one, if that's what you're trying to do.

    HTH
    Sigrid

    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message


  • 3.  RE: Transform Rules

    Posted 03-12-2020 10:52

    Thanks for the reply Sigrid.

     

    I now have some wonderfully complex (with nested If statements!) working very well!

     

    Appreciate you answering.

     

    Cheers,

     

    Andy Reid

     

     

     

    AstraZeneca UK Limited is a company incorporated in England and Wales with registered number:03674842 and its registered office at 1 Francis Crick Avenue, Cambridge Biomedical Campus, Cambridge, CB2 0AA.

    This e-mail and its attachments are intended for the above named recipient only and may contain confidential and privileged information. If they have come to you in error, you must not copy or show them to anyone; instead, please reply to this e-mail, highlighting the error to the sender and then immediately delete the message. For information about how AstraZeneca UK Limited and its affiliates may process information, personal data and monitor communications, please see our privacy notice at www.astrazeneca.com




    Original Message


  • 4.  RE: Transform Rules

    Employee
    Posted 03-12-2020 10:56
    That's great news, Andy!  Congrats!

    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message