Parameter as a list?

James T Sidebotham

Hi, is it possible to have a parameter use a list? So the same workflow gets run for a list from an input file? I have a report that I want to run, many times over based on a a county name from a list. Right now, I have to change the parameter manually.

Thanks

Josh Boxer

Hi James

The way to do this would depend on the length of the list and how frequently the values change. Assuming the list is fairly static and say 20 or less values then you could use a Schedule:

https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/monitor-data-and-troubleshoot/schedule-jobs/#parameters

Each time a Workflow (in this case the same one) runs you can specify a Parameter (and other properties)

George_Stephen

@James Sidebotham Just a suggestion: Make the work-flow usable in other workflows. Create another wrapper workflow to execute the main worflow with different parameters for each country.

James Sidebotham

Hi, I did think about that, but i would still have to hardcode the parameter values. I was hoping to use a flat file that could be read and then run for each row. That way it would be dynamic, and i could just change the values in the flat file.

Josh Boxer

Could utilize the API to execute the Workflow with each parameter value in a list:

https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/extend-data-studio-functionality/use-the-rest-api/#execute-and-manage-workflows

James Sidebotham

I am not a programmer, so that approach isn't workable for us.