How can I separate the analysis of multiple accounts that use the same bank template?
At the analysis stage the data is combined (into Transactions1, Transactions2 etc) based on the bank_layout column; therefore to separate accounts that use the same bank template, the user must change the bank_layout value for each transaction that needs to be separated. This should be done at the validation stage of processing the data (after the data is extracted), then the amended Excel file must be updated within StatementReader (by right clicking on the StatementReader job and selecting ‘import your corrections from Excel’).
Recent PostsSee All
Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo