Hi guys, I hope the solution to my question hasn’t appeared elsewhere.
So I have one folder that contains many other folders which has multiple text documents inside:
(3 layers in total: BIG FOLDER > Folder > many .txt)
And I want to extract information from ALL text files in all folders into one excel spreadsheet.
I already have a workflow with a “for each” loop to deal with only 1 folder of many text files, and it looks like this:
I first assigned a variable to the path of the folder, then I used a “for each” activity and passed the variable to it so that each item in the folder will perform a subsequent action.
Going back to my workflow, (BIG FOLDER > Folder > . txt), Is it possible to set up a loop so that for each text file in each folder in the BIG FOLDER can be looped? Eventually, I want all text folders be transcribed into an excel file
My workflow looks like this now, is there a way to store the name of each file as a string as the loop goes? Should I use the assign activity to do so?
