Need help with Directory Tool

[MilindG]

Hello all,

I'm bringing in some files using Directory tool but I'm unsure on how to bring in the data. 

I'm trying to read files from 2022-01-01 until current. Please help

FullPath	Directory	FileName
\c\Users\Desktop\Alteryx Files\2019-06-01.yxdb	\c\Users\Desktop\Alteryx Files\Data	2019-06-01.yxdb
\c\Users\Desktop\Alteryx Files\2019-09-01.yxdb	\c\Users\Desktop\Alteryx Files\Data	2023-04-01.yxdb
\c\Users\Desktop\Alteryx Files\2020-05-01.yxdb	\c\Users\Desktop\Alteryx Files\Data	2020-05-01.yxdb
\c\Users\Desktop\Alteryx Files\2022-05-01.yxdb	\c\Users\Desktop\Alteryx Files\Data	2022-05-01.yxdb
\c\Users\Desktop\Alteryx Files\2022-06-01.yxdb	\c\Users\Desktop\Alteryx Files\Data	2022-06-01.yxdb
\c\Users\Desktop\Alteryx Files\2023-06-01.yxdb	\c\Users\Desktop\Alteryx Files\Data	2023-06-01.yxdb

[alexnajm · Accepted solution]

Use a Filter tool to filter the list down to only those that you need! Then you can read them in with a Dynamic Input

[nagakavyasri]

Replace path in Dynamic input tool

[tristank]

Yeah @alexnajm hit it right on the head :D

A little regex e.g. .*\\(.*).yxdb and you can dynamically parse your date. From there just create a condition to filter the dates you need before inputting them all using the dynamic input tool.

Tell us if it works out and have a great day