Looping on Value file name in Parameter Set

[atulgoel]

I have a parameter set having 6 parameters and 20 value file set. I need to run the job in sequence 20 times with different value file name each time.

I have created a delimited list of value file names as below:

ValueFileName1,ValuefileName2,ValueFileName3.... and so on...

Now I wanted to pass ValueFileName1 at first iteration and ValueFileName2 at second iteration.

I am not getting option to pass the value File Name in the job Activity from StartLoop.$counter.

Is there any way to pass the valuefilename to job activity from loop counter?

[ray.wurlod]

No problem. Use an Execute Command activity to read the file (use cat command for example). Remove the line terminator, either using a tr -d command in the pipeline, or using a User Variables activity. You now have a comma-delimited list that the Start Loop activity will be happy with.

[Mike]

Not with the job activity stage unfortunately. It limits you to choosing a value file name from a drop down list. It's not possible to specify a parameter.

As a workaround, you can use the execute command activity to run the dsjob command where you should be able to use $Counter in setting the values file to use.

Mike

[ray.wurlod]

One of us is misunderstanding the question. I have assumed it's the same job at every iteration, having a value passed to one of its parameters.

[atulgoel]

yeah. It will be a same job which needs to be run with different Value File at every Iteration.

To resolve the issue, I have created the file with the values of value file set and reading it using execute command stage and then passing the required value to loop .