Automate

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

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.


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

Original Message:
Sent: 08-03-2020 12:05
From: Sarah Cullingworth
Subject: Using the Transform option (Excel formula)

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

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:
Sent: 08-04-2020 02:01
From: Radoslaw Poziomek
Subject: Using the Transform option (Excel formula)

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

Original Message:
Sent: 08-03-2020 12:05
From: Sarah Cullingworth
Subject: Using the Transform option (Excel formula)

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