Check file exists for dynamic file name

Hi alteryx engineer,

I used fileExists function to check if file exist, but this function only work for the fixed file name, if file name is dynamic and i used * as wild card for the file name, it wont return the expected result.

any solution for dynamic file name?

suppose we have time stamp within the file name and it is not fixed, how could i check those file exists?

Thanks

Help

Accepted answers

messi007

@aeolus187,

Please update the filter with the formula below :

Hope this helps,

Regards,

ReadFile.yxmd

All comments

flying008

Hi,@aeolus187

Dear , Maybe you can give a sample data to show dynamic name?

like this:

FileExists([Engine.WorkflowDirectory])

messi007

@aeolus187,

Have you tried using input directory and filter tools :

In the example below I'll read the file that have Excel at the end of the name :

1- I used an input directory

2- RegExMatch in order to fix the patern

Attached the workflow,

Hope this helps!

Regards,

ReadFile.yxmd

aeolus187

@messi007

Hi messi

suppose we have file name like “client 220412-12:20:31.xlsm”, 12：20：31 is dynamic and I checked the file using “client 220412*.xlsm” but didnt return expected result

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703