Hi @aesanchez ,
You could use the Directory input to determine the file type that you wish to bring in. Then, you can use a text input to create a list of the keywords you would like to include, then simply build a macro with a control parameter of each keyword applying a filter to the filename where the keyword is contained.
This would bring in a list of all, for example .csv files in the folder and subfolders, then will cycle through an bring in all that contain each keyword.
M.
Hi @aesanchez ,
That would only deal with the filenames. Once you've loaded them in then can apply a filter using the same Keyword text input (or whatever format) to search for the words within the content. That part is easy as you are simply dealing with text within the data once it's loaded in.
I've attached the macro for you. Hope it helps.
M.
For some reason it won't allow me to attach macros, so I've saved it as a workflow. You'll have to save it as a macro at your end.
