Hi everybody,
I am trying to build a tax compliance work flow that automatically retrieves fx rates from a website, which the work flow can subsequently append to existing invoices that were issued in another currency (invoices in EUR while tax reporting requires a local currency; e.g., SEK). This website does however not populate daily fx rates (see the output below in red color) as this specific fx rate does not always change on a daily basis. The missing dates cause errors when my workflow tries to append the fx rate for a missing day (e.g., an invoice dated on 2024-01-20). How can I add the dates 2024-01-20 and 2024-01-21 (plus other missing dates) to my overview below while allocating the oldest fx rate to those additional dates (e.g., 11.38 SEK in the example below)? I have attached the relevant part of my workflow as attachment to this question.
| Date | f/x rate (SEK) |
| 2024-01-23 | 11.347 |
| 2024-01-22 | 11.3545 |
| 2024-01-19 | 11.38 |
| 2024-01-18 | 11.364 |
| 2024-01-17 | 11.3925 |
| 2024-01-16 | 11.3215 |
| 2024-01-15 | 11.278 |
Don't have much experience with Alteryx yet, so I am hoping that someone can provide support on this query.
thx in advance.
Yvo van Swaaij
