Hey everyone, spent a few hours searching/trying different things and found something but close but it was an image and couldn’t quite get it to work. I tried to rebuild what they did as thats basically what I want to do but I think I am getting messed up with the flow variable from the loop start to the row filter.
Basically I have a weekly inventory file, that I want to save the most recent week in a folder, rerun the script and it loads all the data into one file. One thing to note, there may be new skus based on the week so I want to join based off the newest file. I also ideally would love to take the date based on the file name and save the column as the date name, but haven’t played with that yet.
Any help would be much appreciated! I attached what I built so far, as well as some dummy inventory files to test.
This is the ideal result, with the item and description and the inventory quantity from each file pulled in. Eventually I will replace missing values with 0’s or do something with them. And the column name is the date name from the file.
Hi @BSFL89 , you don’t need a recursive loop for this task. It can be done with a row to variable loop, looping on each path from the List Files/Folders, reading in the files, grabbing the file date from the path and then after the loop completes, pivoting to tabulate the data
I’ve configured List Files/Folders to pick up the files from the workflow’s data folder, so obviously you’ll want to set that back to your original location
