Hi Celeste -
In order to be able to find all of the rows that could apply, you'd have to use an If on Index condition. This functionality requires that you use Gui Scripting recording mode. Also, during the recording you'd need to identify the Currency column as what you want to use as the index.
Once the recording is completed, you would capture the rows where the amount is actually updated and put an If on Index condition around that, using the currency field as the condition, where it equals USD. You'd also specify for it to find all. This is an example of an if on index condition, not the exact one you would need.
https://support.winshuttle.com/hc/en-us/articles/360023557472-How-to-use-If-on-Index-condition This also includes a video how-to. This video includes an indexed loop, which you wouldn't need since your index is just one value, USD. You would need an indexed loop if you wanted USD and any other currencies, as each of these currencies would end up being an iteration of the loop, one for each currency.
Thank you!
------------------------------
JENNIFER HWANG | SE
Winshuttle North America
------------------------------
Original Message:
Sent: 03-12-2020 10:50
From: Celeste Ling
Subject: Create Condition
Hi Jennifer,
Kindly refer to the attachment. Waiting for your good news!
Thanks.
------------------------------
Celeste Ling | Accountant
Intel Corporation | 60172380166
Original Message:
Sent: 03-10-2020 10:25
From: JENNIFER HWANG
Subject: Create Condition
Celeste -
Can you include a screenshot of what you're referring to?
Thank you!
------------------------------
JENNIFER HWANG | SE
Winshuttle North America
Original Message:
Sent: 03-09-2020 22:54
From: Celeste Ling
Subject: Create Condition
Dear experts,
I need help to create condition for ABNA.
I have a column in SAP which is with multiple currency, and I would like to create condition to look up only for USD and to change the amount to 1500 and the rest remain as default.
I read through the below link but I don't really understand.
Could you please help.
Thanks a lot!
Add If conditions| Winshuttle-help | remove preview |
| | Add If conditions | | For greater control over the data that gets posted to SAP, you can add If conditions to a field or fields. Every field in the If condition is checked against the condition and is processed only if it meets the condition. Studio v11 supports two levels in a condition. | | View this on Winshuttle-help > |
|
|
------------------------------
Celeste Ling
------------------------------