Combining result set of two services into one result set

[Former Member]

Hi,

I have a model where I am getting one result set (6 Fields) from BI query and another result set (3 Fields which gives real time values) from OLTP system. I want to show the output of these two result sets into single result set (7 Fields). I have a common field in both the result sets as key field.

I tried this using UNION operator but I am not able to set the Key fields and also in the table view of UNION operator I am getting any field to be added to table.

Can anyone help me to solve this problem?

Any help is appreciated.

Regards,

Amit

[Former Member]

Hi Amit,

in this case, you have to use the combine-operator. However, this operator needs a key-field in each of these sets. E.g. Combine set (<u>customer-id</u>, order-id, week, delivery-state) with set (<u>customer-id</u>, city, client-class).

The combine operator might not be available when compiling to webdynpro, I did not check that.

Best Regards, Benni

[Former Member]

Hi,

I am doing this desing in VC and I tried using Combine-operator but it gives the report output in the Form View not in Table view.

regards,

Amit