topic Re: tUnite is outputting more rows than input in Talend Studio

tUnite is outputting more rows than input

PhilHibbs — Sat, 16 Nov 2024 07:31:48 GMT

I have a tUnite component that is producing more rows than are going into it, and two that are producing nothing. I suspect that the outputs from the other two tUnite components are going into the first!

Here is the first:

Here is one of the others, showing one row going in and none coming out:

Any ideas? I don't think it is a visual glitch, as the aggregate writes out to a file, and the file is not being written.

Re: tUnite is outputting more rows than input

PhilHibbs — Thu, 04 Oct 2018 10:51:06 GMT

Something weird is happening, because the flow appears to be executing three times every time I run it. Is there something weird happening with having several tUnite components in a job?

Re: tUnite is outputting more rows than input

Anonymous — Thu, 18 Oct 2018 09:41:02 GMT

Hello,

There is no output row from your tMap component. What does your tMap component setting look like?

Best regards

Sabrina

Re: tUnite is outputting more rows than input

PhilHibbs — Thu, 18 Oct 2018 10:08:16 GMT

The tMap is producing no rows because there are no rows going into it. The purpose of the tFixedFlowInput and tUnite is to handle this very situation - I want the tAggregate to output a count of zero if there are no rows, but if there are no rows, then the tAggregate doesn't output anything at all. The tFixedFlowInput created a row with a NULL in a particular column, and the tAggregate counts non-NULL values, producing a zero count.

I have since changed to using a tJavaRow component, and fetching the global row count in a subsequent sub-job.

Re: tUnite is outputting more rows than input

Anonymous — Thu, 18 Oct 2018 10:51:45 GMT

Hello,

Could you please elaborate your case with an example with input and expected output values? We will see if your job design is right size for you.

Best regards

Sabrina