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.
Test 1.knwf (111.0 KB)
Test 2 11.1.23.xlsx (11.5 KB)
Test 3 12.1.23.xlsx (11.5 KB)
Test 1 10.1.23.xlsx (11.5 KB)