Batch Macro help needed

[Nishant2077Goel]

Hi all,

I am not able to run the Batch macro in the sample attached.

I want to iterate the workflow for every observation that is passed through excel sheet in the macro driver in the filter using the Action tool.

Please help!

Regards,

Nishant

[ivoller]

What error are you seeing? Can you share the Excel.

Only thing that stands out is that it looks like the configuration of update action should be against the expression value in the filter.

[Nishant2077Goel]

No error during execution, just the output excel turns out zero records every time.

Data in the driver is not flowing thru the control parameter and action tool. 

This workflow is sample only. The workflow needs to be replicated using the database and few business rules later.

Attached is excel sheet for your reference.

Thanks for your help!

Regards,

Nishant

[ivoller]

Making the minor change to the filter action, I get 4 records output.

See attached.

[Nishant2077Goel]

Request you to please share the details of changes you made. Your output is the exact requirement I require.

Thanks for your help!

[ivoller · Accepted solution]

In the Update Value Action Tool in the macro

1. Expand the filter attribute
2. Select on 'Expression - value="[Program_Name] = "Kaiser""
3. At the bottom of the pane
   1. Check Replace a specific screen
   2. Type Kaiser

See image I posted earlier

[Nishant2077Goel]

Thank you for all your help. Now it is working fine :)

What was the reason that the value had to be manually replaced.