Automate

Welcome to the Automate community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  Using the Transform option (Excel formula)

    Posted 08-03-2020 12:06
    I'm trying to use the Transform Rule with Transaction. 
    What I want is to run a second script that has as an input a concatenation of  2 of the values returned from a first script (Doc Id and Fiscal year).  I only seem to be able to make this work for a single row --ie  all my input values = X2 & Z2.
    Have I misunderstood how this functionality works  -  I would like it to Re-evaluate the formula for each of my header rows ie the row number would increment.




    ------------------------------
    Sarah Cullingworth | IT Support
    Bradford Metropolitan District Council |
    ------------------------------


  • 2.  RE: Using the Transform option (Excel formula)

    Posted 08-04-2020 02:02
    Hi Sarah, you got it right. It's just not too intuitive. Winshuttle wants you to put a formula for the first row of data, then it will adjust it, just like excel would do when dragging down the formula.
    Here's an example of my script + data file that has actual results of the transform. You can see formula in the top, and below 1st row formula calculated by winshuttle.

    Then you can see some 12th row below- as you can see the formula was adjusted by Winshuttle as it moved to next transaction.
    So it will work on its own, you don't need to worry :)

    And additionally if you're chaining scripts where there's a data coming from the previous script result, I would put and 'if' around whole second script that checks if the the first script has actually returned any value. That way it will save your time on not running rows that failed.


    ------------------------------
    Radoslaw Poziomek | BSC Continuous Improvement Specialist
    Owens Illinois | *
    ------------------------------



  • 3.  RE: Using the Transform option (Excel formula)

    Posted 08-04-2020 05:30
    Thanks - working now.  Not quite sure what I have done differently but knowing it should work was a great help.
    Also great tip about using an If function  to "check" the data.

    ------------------------------
    Sarah Cullingworth | IT Support
    Bradford Metropolitan District Council |
    ------------------------------

    Original Message