Five 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
4 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.
Five 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.