I use many Excel Readers and Excel Writers in my workflow, and I want to keep a record to list down the input files and output files of my workflows. Because sometime a file is changed, then I need to figure out which workflows is impacted. Is there a smart way to do this? Thanks in advance.
Without knowing how your workflow is configured and how the input and output files are stored its difficult to offer specific suggestions.
Try this. Top example is a simple example of using a file connector. I don’t live in a corporate environment so everything I have is stored locally. The same approach should work with the appropriate connector to a remote file location.
I know this is a way to read files from a folder. But I want to summarize the files ’ path actual used in the workflow.
You want to extract all of the input and output files actually used in the workflow? Are all of the potential input files stored in the same folder? Same with output files. I gather there are also files in the input/output folders which are not used in a given workflow.
Yes, as there are many files in the folder, but I just want to keep the records that files path used in specific workflow.
How are you setting the individual files to read in each Excel Reader? Manually?
Yes. As a result, if I want to summarize the files used, I have to manual record the file path one by one.
Try this. It adds complexity to your workflow, but it extracts the input files you’ll use. It could be made more sophisticated with a widget to feed the Row Filter nodes.
2 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.