Problem with Numeric.sequence

[Anonymous]

 Hi there,

I have a little problem, I use a tFileOutput with a numeric.Sequence("s99",1,1) so it created a file named : name_1.csv 

Then I use a tFileInput with a numeric.Sequence("s100",1,1) but it says " can't find the file name_2.csv" ... But I should be name_1.csv because I set s99 and s100 as parameter so it's 2 different sequence right ?

Thanks, Sam

[Anonymous · Accepted solution]

This is not the sequence, it is the layout of the job. Whenever you use files for input or output, the filename must be fixed from the beginning of the subjob. The files are initiated or read from, from the start of the subjob. So if you are changing a filename on a row by row basis, it will cause issues. You can get round this by using an iterator link after you have created the filename. Then pass the filename to file component after the iterate link. Obviously it means that you will have to sort your data after the iterate link as well, but this is possible. It just requires a slightly different way of thinking about your job.