topic Union all and union.. in Talend Studio

Union all and union..

Anonymous — Fri, 24 Nov 2017 09:14:12 GMT

Hi experts,
I'm using tunite component it is giving me output for union query correctly
But when I want to use union all
Query how to use tunite component plz help me
If any other component for union all
Plz let me know.

Thanks in advance

Re: Union all and union..

premchandkar — Fri, 24 Nov 2017 14:23:53 GMT

Hi ,

You should be getting the union all as well using the tUnite component,

Can you please mention the screen shot of your job ,

Can you confirm whether the schema's are same for the input's ?

Thanks,

Premchand

Re: Union all and union..

Anonymous — Tue, 28 Nov 2017 07:10:39 GMT

Hi,

@uganesh wrote:
Hi experts,
I'm using tunite component it is giving me output for union query correctly
But when I want to use union all
Query how to use tunite component plz help me
If any other component for union all
Plz let me know.

Thanks in advance

Screenshots of your current job design will be helpful for us to understand your job requirement.

Best regards

Sabrina

Re: Union all and union..

Anonymous — Mon, 11 Dec 2017 07:06:50 GMT

I'm having two oracle input components and where two inputs having the same structure when I am using tunite component

it is giving me union output , but i need all the union all output ,I should change any settings in tunite component.

Thanks in advance..

Regards,

Sumanth.

Re: Union all and union..

Anonymous — Mon, 11 Dec 2017 08:43:16 GMT

Hello,

You will get the merged content by using tUnit component if your inputs have the same structure.

Please have a look at my screenshots

Best regards

Sabrina

Re: Union all and union..

Anonymous — Fri, 19 Jan 2018 15:46:14 GMT

Hi,

When I'll have the same record content issued from the two input flows, tunite will keep it twice in the output or will generate only one?

Thanks,

Re: Union all and union..

Anonymous — Tue, 23 Jan 2018 07:09:42 GMT

Hello,

The tUnite component will keep it twice in the output.

What does your job requirement look like? Please set an example for us so that we can design a demo job for you.

Best regards

Sabrina

Re: Union all and union..

Anonymous — Thu, 22 Mar 2018 15:59:28 GMT

Hi,

My need is to reproduce the data base behaviour when using union instead of union all.

the union (in the db) will perform an implicit "dictinct". Can we do same with Talend without additional component?

Regards,

Re: Union all and union..

Anonymous — Mon, 26 Mar 2018 04:10:05 GMT

Hello,

With distinct function, here is a tAggregateRow component which provides the aggregation key and the relevant result of set operations (min, max, sum...) to aggregate flow.

For more information, could you please take a look at online component reference about:TalendHelpCenter:tAggregateRow.

Let us know if it is what you are looking for.

Best regards

Sabrina

Re: Union all and union..

manodwhb — Mon, 26 Mar 2018 06:08:27 GMT

@uganesh Sicne tUnite will perform Unoin All operation,so if you want o get unique then you need to use tUniqRow after the tUnite on all the columns to delete duplicates.please find the below screenshoot.

Re: Union all and union..

manodwhb — Tue, 03 Apr 2018 10:23:41 GMT

@uganesh,still do you have an issue?