This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
Both of these can be partially accomplished with the output of the directory tool:
- List Directories - Summarize unique list of directories from the directory tool output
- Exclude Paths - use filter tool to exlude files or directories based on patterns
However, here are some scenarios that aren't addressed cleanly:
- Directories are not listed unless there is a file contained within. The tool is called Directory, but it only lists files. The directory has to be non-empty to be listed. An option is needed to either list files and/or directories (including empty optionally)
- I can't figure out whether the file specification is a wildcard expansion only or supports regular expression for inclusion/exclusion. I see in the File Browse tool that you can list multiple formats e.g. Text Files (*.txt)|*.txt|All Files (*.*)|*.*. Here is a use case where this is required. Our network shares have Windows file restore snapshots stored in a ~snapshot directory. We don't want the directory tool to traverse this directory (because it literally takes hours to scan), but there isn't an elegant way to exclude it. If you filter it from the directory tool output, it's already scanned it. What we've done is generate the top-level directory list outside of the tool and fed it into a macro that has a directory tool (with sub-directory scanning enabled) inside.
- Another way to address this specific scenario woudl be to have an option to exclude traversal of "hidden" folders. But a more generic approach is ideal.