Please take the attached project, run the workflow Rename and Sort Invoices and at the first activity (Select Folder), please select the folder Invoices.
Process Invoices2.zip (441.4 KB)
The folder contains invoices in CAD, USD and RON.
In the sequence “Sequence get xRate for invoice in foreign currencies” I try to obtain the following: if I already searched on Google for the exchange rate CAD (for instance) - EUR, not to search again if I find another invoice with the same currency.
If the foreign currency is new, to add it in the dictionary rates <String, Double> , where the key is the currency ISO and the value is the xrate with EUR.
However, the robot never chooses the middle path (not to search again for the same xrate). It only goes on the left or on the right path.
I know it’s a lot to digest. But if some of you have time, please help me!