Recursive Loop File Import with Joiner Help
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.
Hi there, i am sure there is a more easy way to accomplish the workflow that i created: [20200226_KNIME Analytics Platform - :Users:paolo:knime-workspace] As you can see i would like to join and append within a starting file a specific column from each excel files in a loop. Is there anyone that can help me please? Thanks