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

Currency_Filter_I_06052024.yxzp