How to create a date column in each file when using Directory and dynamic input

ankurrjit

I have a workflow which is using "Directory" input and then Dynamic input based on "FULL PATH". each file from full path is having a date field "Effective date", I want to add another field "Date Created" alongside which holds the min or max effective date from the same sheet.

The reason is there are many rows in each file having NULLS for field "Effective Date". 

I tried many options formula and the multi-row formula but it is giving weird results. 

Please note that the output of the workflow is set as CSV with "Max Records Per file" as 1048570, so it is combining a set of files and then creating new files for another set of files.

Please help.

files from multiple folders.yxmd

ankurrjit

Hello @RobertOdera  - I have made it work. Here are the details.

In dynamic input I selected the option "output file name as field" and pass the "filename only". All the files which are generating are having their creation date as a suffix. Next step I am picking the date out of this field and using it as date created. Thanks a ton for looking into this for me.