Using the Union Operator in VC

[Former Member]

I am looking for a way to create a table in VC which contains fields from two different tables, both of which are outputs from a BAPI.

I've tried using the Union operator but am having problems with it.

Are there any suggestions?

[Former Member]

Hi,

what problem you are facing?

Regards,

Govindu

[Former Member]

We thought that using it would allow us to essentially merge two tables with some common fields into a further table which contained all the data we wanted to view. However, it appears that you can only merge tables with all the same fields in.

[Former Member]

Hi,

Use Combine operator insteda of Union for yur requirement.

Govindu

[Former Member]

Is the operator only available with VC 7.0? It doesn't appear in our list of Operators in our VC environment.

[Former Member]

Hi Emily,

Combine operator is only available in 7.0 and not in VC 7.1

Regards,

Dharmi

p.s. There are some threads in the forum that you might want to look into:

["Combine" in 7.1? |;

[How to use the Union operator|;

[union info from two datasources |;

[On Merge|;

[Merge several fields into one Input structure|;

[Former Member]

Thanks for your help anyway. Not really a way of doing what we want in VC at the moment then by the looks of things.

[Former Member]

Looks like we need an INTERSECTION OPERATOR .