@FreelanceReinh wrote: @ballardw: Good explanations. Minor correction: The combination of SEXCL='Y' and modified START values, e.g. 1913.34, causes unwanted (small) gaps between the ranges, e.g. put(1913.34,expenditure.)='1913.3', but should be '465.96'. Right. I didn't bother to check OP ranges mostly to demonstrate the CNTLIN. ... View more

If it's able to look for new files I imagine the On New File trigger could work for what I'm doing. If I can't make the code above work I'll look into that, thanks for the tip! To clarify, it's an ongoing list of raw files sat in the SFTP, they get added to every day with data from the previous day. The code will take only the latest data, manipulate it as desired and then append it into another dataset. Processing everything at once would take ages so isn't suitable for a daily job. ... View more