Filter Required Data Based on Values from Another Dataset

Transformations:
array functions (arrayintersect, arraylen), extractlist, list, join, filtering (keep)

This template shows how you can filter your data based on values found in another reference dataset. It makes use of array functions such as arrayintersect after extracting all the values to look for in the reference dataset into an array via the list function.

To customize this template for your own use case, supply your own reference dataset in place of categories.txt and modify the Find values and filter recipe to accommodate the number of columns in your source data for the filtering.