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 : )
Solved! Go to 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
Hi @JulioMO,
Thanks for the solution!