Skip to main content
N
Nirod95
Newcomer
March 21, 2025

Multi year worflow load

  • March 21, 2025
  • 1 reply
  • 0 views

Is it possible to have a Scenario Type with a 5 year input frequency?

I need to be able to load 5 years at once instead of having to change the wf year 5 times.

is it possible?

1 reply

S
SimonHesford
Newcomer
March 21, 2025

In terms of a workflow the least granular input frequency is Yearly. If you don't want the hassle of loading each year in the workflow then you can have a number of options.

Use a Matrix data source load with the time period loaded to driven from the amount columns. 5 years of data can be loaded from one workflow. Similarly you could set up an Excel template load to load 5 years in one go

Set up a batch load process which would automatically process 5 years of data if the data was in 5 separate files  

Terms & ConditionsAccessibility statement