Hi all,
I'm trying to build a workflow that:
1) Reads all files within multiple subfolders
2) Reads only the excel documents that contain "725" in their folder name
3) Opens each of these excel files and extracts data from the sheet "M3"
4) This is where it gets complicated as some sheets do not have this tab - I just need them skipped without stopping the workflow.
5) Appends all extracted data into one output excel file.
I've tried using Directory > Filter > Dynamic input but I'm running into issues where Alteryx throws errors for files that don't contain the M3 Sheet.
Has anyone done anything similar? Any suggestions? I tried the batch macro approach too.
