Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Batch macro, update value automatically does not work

EstherHesseling
7 - Meteor

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 : )

 

workflow.png

macro filter.png

 

2 REPLIES 2
JulioMO
9 - Comet

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.

Capture.JPG

Let me know it they work for you. 

 

Regards

EstherHesseling
7 - Meteor

Hi @JulioMO,

 

Thanks for the solution!

 

 

Labels