Dynamic Input: Extract Files of COB Date yesterday

[bubblyjai1982]

Hi All,

Kindly help in extracting the multiple files as of COB yesterday.

The File name contain the date i.e. File name start with a prefix of Date and followed by Sec id... So on daily basis multiple files will be saved.

Example: 

20250805_EMTNUSD080633DBINL03

20250805_EMTNUSD080735DBINL02

20250804_EPTNUSD080830DBINL02

20250804_EXTNHKD060755DBINL03

20250804_EMTNEUR080830DBINL02

20250804_EMTNUSD060755DBINL03

20250801_EMTNAUD081132DBINL01

20250801_EMTNJPY081050DBINL02

20250801_EMTNUSD080940DBINL08

20250831_EMTNUSD080633DBINL03

20250831_EMTNUSD080735DBINL02

Using dynamic input tool I'm trying to extract the files of COB yesterday date i.e. 20250804

I have attached my workflow, please advise if there is any easiest way to extract the multiple files containing COB date yesterday.

Thanks

[binuacs]

@bubblyjai1982 Try the below condition in the filter tool 

[binuacs]

@bubblyjai1982 updated workflow attached

[bubblyjai1982]

Thanks Binu !!

Actually I was able to create until filters tool but when I tried using Dynamic Input tool: Not able to extract all files, getting error like

"Dynamic Input (134) Error opening table: Microsoft Access Database Engine: The Microsoft Access database engine could not find the object 'xlsb'. Make sure the object exists and that you spell its name and the path name correctly. If 'xlsb' is not a local object, check your network connection or contact the server administrator.\3011 = -543884569"

I tried a few different things by adding the formula tool and some settings on the Dynamic Input tool but I'm still getting the same error

I'm using 2024.1.1.178 Version 

Thanks

[binuacs]

@bubblyjai1982 is your input files are .xlsx or .xlsb? what is the template file selected in the dynamic input tool? can you try the template as .xlsx file in dynamic input tool?

[bubblyjai1982]

Hi Binu... The files are in.xlsb format. Don't want to change the format to xlsx because it contain formulas and calculations.

[binuacs]

is the dynamic input tool working with one..xlsb file?

[bubblyjai1982]

Yes please, using Input Data Tool able to access the files and generate the output properly.

[binuacs]

@bubblyjai1982 can you make sure that the directory tool only picks the .xlsb files

[bubblyjai1982]

Yes, have used xlsb as file specification.

Not sure if this issue is due to Alteryx version