Correct/replace data in load script via separate Excel
I have an existing data model where there is data per month per account. For a certain dimension I would like to correct the source data via a separate Excel file (I could do this in the source data, but I rather have a clear view on the corrections done via this excel).
How can I do this in the load script? Below you'll find a short example of what I want to do.
For account 98745 the dimension was not correct in the source data for Period 201701 & 201702 (replace ABC with BCE), this will be given in the correction file.
Source data (%PeriodAccount is a concattenated field)