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

Multiple File Extract.yxmd

Workflow

Accepted answers

All comments

binu_acs

@bubblyjai1982 Try the below condition in the filter tool

binu_acs

@bubblyjai1982 updated workflow attached

Multiple File Extract.yxmd

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

binu_acs

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

binu_acs

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.

binu_acs

@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

binu_acs

If it is working for you with the input tool it should work with the dynamic input tool as well. is the sheet names are same for your input .xlsb files I mean all are having sheet1 as the sheet name?

DawnDuong

There were reported bugs when using Dynamic Input Tools with large / multiple .xlsb.

How to Enable Microsoft Excel Binary (XLSB), Excel Legacy (XLS), Access (ACCDB) for In/Out tools

XLSB File Crashes Designer

If all fails, perhaps you can consider doing a batch macro instead?

Dawn.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703