community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

SubDirectories level limitation

Hi all,

 

Is there a way to limit the level of subdirectories being harvested?

In my case, there is a 1st level with the year, a second level for the months and a third for the days. I would like to go just up to this level, because the files I need are there.

However, there are numerous other subfolders with useless data that are consuming lots of processing performance.

 

Thanks!

Alteryx
Alteryx

Are you using a directory tool to get the list of files that are then fed into a dynamic input?

 

If this is the case, you could create subdirectory number logic by counting the number of slashes in the file path, and then filter out files with a level count above whatever threshold that you specify. 

 

The directory tool would still take the processing time to identify the file names, but you could limit the number of files that were actually read in by filtering out the files that aren't relevant. 

Meteoroid

How would you filter based on the number of slashes? From what I can tell I can't just type in "\\\" into the filter tool.

 

 

Alteryx
Alteryx

Take the following as an example

 

Folder Names

C:\users\username\Desktop\

C:\users\username\Desktop\parentfolder\

C:\users\username\Desktop\parentfolder\childfolder\

C:\users\username\Desktop\parentfolder\childfolder\anotherchildfolder

 

Text to column on folder names with \ as the delimiter into 6 columns as an example. Now if you only want to pull the directories that go to the parentfolder level you could add a filter tool and say [6] isnull. 

 

parse to columns.pngparse to columns filter.png

 

 

Meteoroid

Ohhhhhhh. Very cool. Thank you. First time using the text to columns :D.

Labels