Union all and union..

[Anonymous]

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

[premchandkar]

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

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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,

[Anonymous]

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

[Anonymous]

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,

[Anonymous]

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

[manodwhb · Accepted solution]

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