I've been exploring the CreW macro (source: http://www.chaosreignswithin.com/p/macros.html) that returns only unique entries, and I'm looking to build a macro that incorporates this CreW macro with dynamic input.
I want the workflow to accept two inputs:
- Target Field Names File: A comma-separated list of field names (could be one or multiple).
- Data File: The dataset in which these fields are located.
| Industry | FirstName | LastName | Age | YearsOfEducation | YearsAtCurrentJob | Salary |
| Communication | Ronald | Dryer | 43 | 16 | 5 | 83000 |
| Manufacturing | Angelina | Prissant | 33 | 18 | 4 | 87000 |
| Manufacturing | Tara | Jackson | 28 | 12 | 6 | 35000 |
| Communication | Keith | Jacobs | 56 | 14 | 8 | 63000 |
| Manufacturing | Terrence | McKinley | 26 | 18 | 2 | 80000 |
| Manufacturing | Wilma | Holmes | 63 | 16 | 12 | 77000 |
| Communication | Mark | Hodges | 46 | 12 | 2 | 34500 |
| Software | Danielle | Rodriguez | 29 | 22 | 1 | 108000 |
| Software | Michael | Lawrence | 53 | 16 | 7 | 93000 |
| Software | Michael | Lawrence | 53 | 16 | 7 | 930 |
| Software | Christina | Kim | 32 | 16 | 4 | 88000 |
| Software | Christina | Li | 32 | 16 | 4 | 88000 |
Expected output (in this example):
| Software | Michael | Lawrence | 53 | 16 | 7 | 93000 |
| Software | Michael | Lawrence | 53 | 16 | 7 | 930 |
I have created and attached a method using the regex tool, but I realized this doesn't work when the input file changes.
Could anyone advise on the best approach to achieve this in Alteryx? I’d appreciate any guidance on dynamically incorporating the target fields and efficiently identifying duplicates with the macro.
