I have 2 sets of data stored as Variables, one of which is a financial dump from a Ledger system & the second is an offline reference data mapping file.
I need to translate/map the data from the financial data dump across into a new file/ Journal based on the mapping file.
I cant provide examples due to the sensitive nature but for a bit more context, the financial data has Account detail, the mapping file is based on Account which then defines the remaining financial string for said line so its just a one to one account mapping that then needs to return the full string from the mapping file.
How would I best go about doing said mapping?
Any and all help would be hugely appreciated!