I am working on a POC on Knime to be implemented as an ETL tool. I have a requirement in which I need to process files(loop through) that are delivered in S3 bucket and load it in Redshift and after that move the processed files(One by one in the same loop) into another S3 bucket. I am not sure how to move the files within S3 as a part of the loop one by one.
In the screenshot attached I am able to loop through the files and load them into Redshift in sequence.
I need to know how to use a component to move files between S3 buckets.
Any help is appreciated.