Hello,
Is it possible to filter a field dynamically using a list (either a text input list or an input file) without using a macro?
Grateful for guidance!
Thanks,
Valerie
Hi @valeriemattas ,
I believe you can use a Find & Replace tool for that. You can create a flag for every keyword, and then use the Find & Replace tool to look within the Foods list column for the value contained in the Key word column.
Then, if a match can be found across the whole string, you will append the Keyword flag. After the Find & Replace tool, all Food records that are not in your keyword list, will have a null Flag, and you can then filter them out.
It appears 31 foods have the provided keywords.
Hope that helps,
Angelos
@valeriemattas,
I don't think that you can do this without Batch Macro.
Could you please develope more what you want to do with a sample data it will give us more ideas.
Best Regards,
Hi @messi007
Thanks for your quick response! To simplify with sample data, see the attached files. One is a list of keywords and one is the data set we are analyzing.
We'd like to filter the Food List using the Keywords without creating a filter with multiple "OR" statements, given the Keywords list is a document we'd like to update periodically. As such, hoping to have a dynamic filter.
Thanks!!
You could add an input file (File A) with the same field headers as the main file (File you want to filter. Fill in the column of interest (e.g. Sales Month) in File A with the values you want to filter on. In Alteryx, join both input files and your filtered list will be the join option J which is a list of records that have the same Sales Month in both files.
