How can I use the action tool to update my filter to one or more selections from a listbox

[wonka1234]

hi,

How do I use my listbox tool to select a date range in my formula?

Listbox:

Filter tool 

Contains([FullPath],"202209")

Action tool:

How can I use the action tool to update my full path contains to one or more selections in the list box?

[CarliE]

@wonka1234 ,

can you share an example of what your full path looks like? 

[christine_assaad]

Hi @wonka1234 

You can use the "Date" interface to allow end users to pick the date of choice.

In Alteryx, when you go to Interface and click "Date" you will find a link to an example that shows how this tool could be used with a filter to filter your data. Hope that helps. Cheers!

[wonka1234]

@CarliE \\alteryx\202209\FileRec_202209.del

[CarliE]

@wonka1234 

Attached is a workbook! I parsed out the date from the file path and used an in statement to allow for multiple selections -- you can also convert it to a date format and do what Christine mention (using the date interface tool)

If this helped and solved your issue please be sure to mark it as a solution!

Thanks!

[wonka1234]

@CarliE 

Hi.

Im using the directory tool. It looks and finds all the folders and files within it.

Then I use a contain to find the required month. Ie 202209 

Can you do an example with directory tool:

202209\FileRec_202209.del

202210\FileRec_202210.del

I then your dynamic input tool to read in the file.

[CarliE · Accepted solution]

@wonka1234 ,

hi! 

if you change the text input to the directory tool this should work. Instead of using field1 you would use FullPath. See attached.

[CarliE]

@wonka1234 or do you need that specific month dir only and those files within that month dir? not only the file names with that month?

[wonka1234]

@CarliE  anyway you can upddate it using my contains for full path? 

I have multiple files within the 202209, 202210 folders and I only want 1 per each folder selected.

For example

Contains([FullPath],"202209") and Contains([FullPath],"OIA_FileRec")

I want to technically do this 

Contains([FullPath],"202209, 202210 or whatever else is chosen") and Contains([FullPath],"OIA_FileRec")

[CarliE]

@wonka1234 

just add to the filter and Contains([FullPath],"OIA_FileRec") the piece that will be updated is the "date" field for whatever is chosen in the list box.