Union all and union..

Six Stars

Union all and union..

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

Accepted Solutions
Twelve Stars

Re: Union all and union..

@sumanth 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.

Untitled.png

Manohar B
Twelve Stars

Re: Union all and union..

@sumanth,still do you have an issue?

Manohar B

All Replies
Four Stars

Re: Union all and union..

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

Moderator

Re: Union all and union..

Hi,


sumanth 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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Union all and union..

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.

 

Moderator

Re: Union all and union..

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

1.png2.png3.png

 

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Union all and union..

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,

Moderator

Re: Union all and union..

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Union all and union..

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,

Moderator

Re: Union all and union..

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Twelve Stars

Re: Union all and union..

@sumanth 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.

Untitled.png

Manohar B
Twelve Stars

Re: Union all and union..

@sumanth,still do you have an issue?

Manohar B