VC Union Operator

[Former Member]

I want to do following, but this is not working using union operator in VC 7.2 , please suggest me if this is possible or not?

I can able to merge the two different tables in vertical but not possible to merge in horizontal

WS1 returns rows for like

field1 ,field2, field3, field4

row 1 - 001, ABC, XXX, YYYY

row2 - 002, ABC, XXX1, YYYY1

row3 - 003 , ABC, XXX2, YYYY2

WS2 returns rows like (field1 is key for both the WS1 and WS2)

field1, field5, field6

row1 - 001, FFF1, KKK1

row2 - 002, LLL1, UUU2

I want to merge both and wants to get the output service WS3 as

field1, field2, field3, field4, field5, field6

row1 - 001, ABC, XXX, YYYY, FFF1, KKK1

row2 - 002, ABC, XXX1, YYYY1, LLL1, UUU2

row3 - 003 , ABC, XXX2, YYYY2

[former_member341000 · Accepted solution]

Hi,

What you're looking for is a join operator, not union.

Unfortunately, such an operator is not available in VC. You should create a backend service for that purpose and use it instead.

Best regards,

Tal.

[Former Member]

answered.