Hi, I need your help to construct a Dynamic Input tool with few rules & conditions. * In a sharedrive path (a fixed directory) * we would have a folder (somewhere there) for last working day and that date would be the folder name; for example, if today's date is 25th May then folder name would be 20200522. But date format is not fixed. * the file name would have 'xyz' but should not have 'pqr'; file name would also have the folder date. like 20200522; but again date format is not fixed. * File format could be any excel format (.xls , .xlsb , .xlsx..) Then workflow should process that file. Kindly guide me. Mohit @grossal @DavidP

Dynamic Input (with few rules)

mohit9garg

Hi,

I need your help to construct a Dynamic Input tool with few rules & conditions.

In a sharedrive path (a fixed directory)
we would have a folder (somewhere there) for last working day and that date would be the folder name; for example, if today's date is 25th May then folder name would be 20200522. But date format is not fixed.
the file name would have 'xyz' but should not have 'pqr'; file name would also have the folder date. like 20200522; but again date format is not fixed.
File format could be any excel format (.xls , .xlsb , .xlsx..)

Then workflow should process that file.

Kindly guide me.

Mohit

@grossal @DavidP

Workflow

Input

Dynamic Processing

Accepted answers

grossal

I probably should have said this, but the Generate Rows was only for the creation of sample data. Remove it in your workflow.

Use the DateTime Tool to convert the name to a date like this:

Make sure to name the Field 'Date' (or rename it in the formula accordingly)

Best

Alex

All comments

grossal

Hi @mohit9garg,

I think the first thing you need is the directory tool for the shared drive - make sure to Include SubDirectories.

After this we can use a Filter-Tool to figure out the right file. The filter probably needs something like:

Contains([FileName], Replace(DateTimeToday(),'-','')) 
AND NOT Contains([FileName],'second condition')

You could pass this information into a Batch Macro that reads in the file. This should look like:

I would probably tick "Auto Configure by Name" - just in case:

The main workflow would look like this:

Let me know if this helps. I won't be able to build an exact workflow because I don't have access to your drive etc, but this should give you a good idea how to continue.

Best

Alex

danilang

Hi @mohit9garg

@grossal gave you a great start on this. The biggest remaining issue is your statement that says "the date format is not fixed" The suggested solution gives you the date part of the directory and file names in yyyymmdd format. Which other formats are possible? If the format isn't fixed, how do you handle ambiguous dates? 20200102 could be Jan 02 or Feb 01

Dan

mohit9garg

Hi @danilang - Thanks for noticing. I am putting this ask aside for the time being. Let me try to build a workflow with fewer conditions. 🙂

Thanks @grossal for the solution. But could you please advise how could I achieve below-

we would have a folder (somewhere there) for last working day and that date would be the folder name; for example, if today's date is 25th May then folder name would be 20200522. But date format is not fixed.

I need to find the folder fist in the main Directory which contains the date of last working day; which is in yyyymmdd format. Because actual excel file won't have the date.

Thanks,

Mohit

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703