dynamic configuration of multiple Filter

[BRRLL99]

Dataset-1                                                                                

CRNCY	Amount
A	100
B	200
C	120
D	110

 Dataset-2:

CRNCY	Amount
A	10
A	100
A	25
B	200
B	20
C	200
C	100
C	350
D	400
D	100

Expected Output:

I need two outputs 

1. CRNCY and amount matched

2. CRNCY leftover items which did not match

I have created the expected output using batch macro,

connecting macro to two different filters and two different control parameters

When i used the same macro to my original data set, I'm not getting the result

dynamic configuration of multiple Filter Tools fro... - Alteryx Community

output: 1

CRNCY	Amount
A	100
B	200

output: 2

CRNCY	Amount
C	200
C	120
C	350
D	400
D	100

[binu_acs]

@BRRLL99 Are you not expecting Currency D and Amount 100 in your first output data set? they meet your first condition

[BRRLL99]

Sorry,

I have updated the dataset , 

Please look into it.

[binu_acs]

@BRRLL99 One way of doing this

[BRRLL99]

can we do the same using batch macro?

As shown in this example:

dynamic configuration of multiple Filter Tools fro... - Alteryx Community

[binu_acs]

@BRRLL99 The given post basically works on filters but your use-case is looking for matching and unmatched values. I am not sure this is vest suited for a batch macro. You mentioned you created a batch macro for this?

[BRRLL99]

As shown in the image , i just created two filters , and attached control parameter each filter 

[binu_acs · Accepted solution]

@BRRLL99 you have two input files and the requirement is to compare these two files and give the output, I am wondering how can you achive this using a filter tool? Also in your macro you are connected to only one input file. I still dont think it is a batch macro thing, i created a batch macro any way