Creating an Array

lynettejackson

Hello Guru, Alteryx is new to me. I need to build and output files that display only the 20 SAP equipment records. I have tried Content and Regex functions, and I am not executing nor outputting the file successfully.
I am used to using an "In the List" function, but I do not see such a function in Alteryx.

Example:

REGEX_Match([Equipment],'12253863') or
REGEX_Match([Equipment], '12297249') or
REGEX_Match([Equipment],'12326664')

Per

@lynettejackson ,

I am not quite sure I understand your input or expected output, but I will give it a shot:

If you have a table of data, and need to output a subset of that data, then you can either use the Contains() function for each of the 20 record types (if they are substrings), or you can have them as a list, and do a join with the original data (if you have the exact equipment types of course). Please see the mockup below. Will that solve your case, or did I misinterpret something?