topic Re: Using tSortRow after reading multiple files to sort across all rows in Talend Studio

Using tSortRow after reading multiple files to sort across all rows

mobmsc2 — Fri, 15 Dec 2017 15:36:37 GMT

I have a directory of files which I iterate through and output to 1 master file. I would like to sort all the rows in a particular order before outputting to a file but because I'm iterating through multiple files my output is automatically separated into batches based on the flow of rows through my job.

Is there a way to sort all the rows without having to read in the master file?

Re: Using tSortRow after reading multiple files to sort across all rows

TRF — Fri, 15 Dec 2017 15:46:07 GMT

Hi,

tFileList --> tFileInputDelimited --> tHashOutput

+ on Subjob OK

tHashInput --> tSortRow --> tFileOutputDelimited (sorted with all records)

Hope this helps.

Re: Using tSortRow after reading multiple files to sort across all rows

TRF — Fri, 15 Dec 2017 19:32:30 GMT

Does this answer solved your case?
If so, thank's to close the subject.

Re: Using tSortRow after reading multiple files to sort across all rows

mobmsc2 — Mon, 18 Dec 2017 10:57:40 GMT

In this case would tFileList trigger SubJob Ok when all files have been read or after each file was read?

Re: Using tSortRow after reading multiple files to sort across all rows

Anonymous — Mon, 18 Dec 2017 11:29:17 GMT

The subjob starts to work only when all files are read.

Re: Using tSortRow after reading multiple files to sort across all rows

TRF — Mon, 18 Dec 2017 11:34:52 GMT

"on Subjob OK" means "when the subjob is finish with success", so in this case when all the files have been read.

Re: Using tSortRow after reading multiple files to sort across all rows

Anonymous — Tue, 19 Dec 2017 08:40:26 GMT

Hello,

Here is a document about https://community.talend.com/t5/Design-and-Development/What-is-the-difference-between-OnSubjobOK-and-OnComponentOK/ta-p/21696.

Hope it will be helpful.

Best regards

Sabrina