Obviously this works if my data docs are already placed in the correct subfolders.Īppreciate this may be really basis stuff for most of you but hey, small victories are all progress. If contains(,"London") then "London" elseif contains(,"Midlands") then "Midlands" else "" ENDIFĪdd extra elseifs with extra criteria as requiredfor more regions / years I over complicated my thinking for the solution by originally of thinking in excel terms and looking to use "len" and "lefts" "rights" and "mids" functions once i'd located the number of characters before the "\" in the file path.įar simpler solution when sub-folder names are predefined is just to use an if then formula with "contains" function - eg for financial year, and as the field name What I was trying to do, having already captured my original separate excel data by criteria like region and financial year already into sub-folders was to use a string formula to find the relevant sub-folder name from the file path, to then use that sub-folder name in a new column for Financial year and region.
#EXPORT LIST OF FILES IN FOLDER AND SUBFOLDERS HOW TO#
I could almost certainly work out how to do this in excel with string functions, but not got my head around Alteryx for same things.
That would save me running multiple different workflows separately as I could set the inputs to the top level directory, and tick include subdirectories, Is there a way to extract subdirectories out of the file name or file path string and use those output in a formula to auto complete the above fields. I have a bunch of separate multi tab excel files (manually selected to ensure common schemas in each folder) that I'm mining for cost data in various different ways.Īt the moment to do this I'm having to create input datasets in separate folders and subfolders for each "workstream" and/or "project year" and using formulas to create new columns which simply have a number constant eg "2018" for year or a text constant for workstream eg "office maintenance" I wiIl do them separately so they become different threads as not wholly connected. None of which is wholly relevant to the questions I have.
New to Alteryx (from September) and this whole brave new world having spent years of my life on Excel, more recently Power BI, and occasionally Access.
0 kommentar(er)
