Hello Community, counting on you to help me on this!
I need Alteryx to create rows for the missing dates (see blue arrow) below as the original data jumps Bank Holidays and weekends). I also need the program to copy the currency rates from the next available day. In the example, I expect Alteryx to identify there are missing dates for the month and add rows for the 9th and 10th January and copying the other columns from the 11th Jan.
PS - This needs to go into the server for other people to run, so macros dont go well in the server (these were my first choice). My seconf option was to use the Generate Row function but it is still confusing to apply it against more complex operations.
Purpose of this is to have the program using theses rates later to convert the company`s tax information, but bank holidays and weekends in Europe do not generate rates even though we might have transactions here in the UK. I am also attaching the original excel file for the rates
Current:
Target
(I need Alteryx to generate the yellow lines for every date that is missing)
