Hello Alteryx Community,**
I'm working on creating a macro that filters out data when they don't match one of the proposed classes.
Input
- Data Table: This table contains the data that needs to be filtered. Here’s a snippet of the data table:
Id Colour Weight
apple1 red 5
apple2 yellow 4
apple3 green 6
apple4 blue 5
apple6 4
- Limit Table: This table specifies the target field names, their corresponding valid classes (separated by commas), and an `EmptyOK` flag indicating whether empty values are also considered valid.
Field Type Classes EmptyOK
Colour Class Red,Yellow,Green True
Output
- Invalid Class Table: This is the expected output, showing rows filtered out based on the example inputs.
Id Colour Weight
apple4 blue 5
I've started working on the workflow, and the files are attached as the two inputs mentioned above. I would appreciate any suggestions or guidance on how to refine this macro.
Thank you!
