Filter Using a List

[valeriemattas]

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

[messi007]

@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,

[valeriemattas]

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!!

Valerie 

[AngelosPachis · Accepted solution]

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]

@AngelosPachis  This works, thank you!

What would you suggest if we want to perform the same review on multiple fields?

[AngelosPachis]

Hi @valeriemattas 

I would suggest using a transpose tool to bring all values into a single column, and then applying the find & replace to the value that contains the values (please have a look at the attached workflow)

Hope that helps, let me know if that worked for you

Cheers,

Angelos

[messi007]

@valeriemattas,

Another way how to it using a dynamic replace.

I added a new column to the the food sheet to test.

Based on which column you want to filter you can use the transpose tool

Attached the workflow, hope it will help,

Regards,

[Abena]

You could add an input file (File A) with the same field headers as the main file (File B) 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.