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 |
Solved! Go to Solution.
@BRRLL99 Are you not expecting Currency D and Amount 100 in your first output data set? they meet your first condition
Sorry,
I have updated the dataset ,
Please look into it.
@BRRLL99 One way of doing this
can we do the same using batch macro?
As shown in this example:
dynamic configuration of multiple Filter Tools fro... - Alteryx Community
@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 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