Batch macro, update value automatically does not work

[EstherHesseling]

Hi all,

I have been working on a workflow in which I would like to use a macro filter. 

In the attached simplified workflow there is different input data.

1) "Entities selected" a column with entities: AR001, BR001 and CR001.

2) "Entities data" a column with entities: AR001, AR002, AR003, BR001, BR002, BR003, CR001, CR002, CR003. 

In input 2 file there is some data belonging to the entity. By the use of a macro filter I want to update the workflow. So first it takes AR001 from the input 1 file and then matches and retrieves the data from input 2. 

Then input 1 needs to automatically update to BR001 and to retrieve the matching data for BR001 from input 2.

At the moment I get the data filtered, but I don't think that it's automatically updating. Could someone give me some help? Would be really appreciated : )

 

[JulioMO · Accepted solution]

Hi @EstherHesseling ,

Attached you will find a solution. I attached also the macro I used in case it does not work within the package. 

You will find two solutions: with and without a filter.

Let me know it they work for you. 

Regards

[EstherHesseling]

Hi @JulioMO,

Thanks for the solution!