Update Control Table with Interface Tool Before Macro

[hellyars]

I have a batch macro with a control table.

The control table has two fields:  Company, Percentile.   The default value for Percentile is 50.

Together the control table and the batch macro work as expected and a file is outputted.

I added a formula tool to update the Percentile if the company name is X and then set the interface / action tool to update the expression and specifically the value 50.

Run produces no errors. 

PROBLEM:  Run as analytical app, select a replacement value runs without errors but outputs nothing.

The control table and the formula tool with interface/action tool outputs directly to yxdb as expected if I take the macro out of the loop.

The control table and macro output to directly to the yxdb as expected if I take the interface/action tool out of the loop.

Separately the work, together they produce no error and no output.

What gives?

[Raj]

@hellyars have you tried debugging the application to see where data is getting eliminated?

[hellyars]

@Raj   Nope.  No time. 

[Raj]

@hellyars are you satisfied with the output generated in debug?

[apathetichell]

something is off on your action tool which is updating the percentile. Can you share a screenshot of the workflow design and the configuration  of that action tool?