I have one folder, containing a lot of files. I also have a list of multiple unique strings, Each one of these strings should be included in one of the files' name of which I am trying to import.
Is there a way to do something similar to the thought process below?
IF
contains( "Key String", [FILE_NAME])
THEN
Input into Alteryx
Else
ignore
EndIf
It is worth emphasizing that each string is unique, but the file name is not simply the string by itself. The file names do not seem to be uniform other than each one containing their Key String. Any insight is greatly appreciated, thank you!
