Problem with Numeric.sequence

Anonymous — Tue, 06 Aug 2019 11:11:29 GMT

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

Re: Problem with Numeric.sequence

Anonymous — Tue, 06 Aug 2019 16:57:11 GMT

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.

topic Problem with Numeric.sequence in Talend Studio

Problem with Numeric.sequence

Re: Problem with Numeric.sequence