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 FullPathDirectoryFileName\c\Users\Desktop\Alteryx Files\2019-06-01.yxdb\c\Users\Desktop\Alteryx Files\Data2019-06-01.yxdb\c\Users\Desktop\Alteryx Files\2019-09-01.yxdb\c\Users\Desktop\Alteryx Files\Data2023-04-01.yxdb\c\Users\Desktop\Alteryx Files\2020-05-01.yxdb\c\Users\Desktop\Alteryx Files\Data2020-05-01.yxdb\c\Users\Desktop\Alteryx Files\2022-05-01.yxdb\c\Users\Desktop\Alteryx Files\Data2022-05-01.yxdb\c\Users\Desktop\Alteryx Files\2022-06-01.yxdb\c\Users\Desktop\Alteryx Files\Data2022-06-01.yxdb\c\Users\Desktop\Alteryx Files\2023-06-01.yxdb\c\Users\Desktop\Alteryx Files\Data2023-06-01.yxdb

Need help with Directory Tool

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

Workflow

Datasets

Accepted answers

alexnajm

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

All comments

alexnajm

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

Screenshot 2023-06-05 154508.png

Getfromdate.yxmd

tristank

Yeah @alexnajm hit it right on the head

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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335