Cannot Change Output File Within a Loop
I'm trying to loop over several excel files in a directory, perform some actions, then output a new file for each one of those based on what I did. My script is performing all of the actions correctly except it will not rename the out file in the Data Sink step. It will just keep using the same file and dump everything into it. I've tried several ways of changing the output file name with no luck (Use property transfer, direct reference, groovy script). I have confirmed through debugging that it is correct grabbing the next file name and performing the actions on all the files. It just wont change the Out File name. Any help or suggestions on things to try would be great. Thanks!