Combine Operator in VC 7.3

[Former Member]

Hello,

in VC 7.0 there was an Combine operator. In VC 7.3 this operator doesn't exist any more.

Is there any workaround to join 2 table (no union)?

Is the Combine operator planed for any further release?

Thanks in advance

Regards

Valérie

[former_member202465]

Hi Valérie,

From what I understand the 7.0 Combine Operator  was a unique implementation based on the Flex technology, so we don't have it in 7.3.

We might still be able to help: please describe the scenario you're modeling and let's see if anyone here could suggest a solution with 7.3 tools.

Thanks,

Udi

[Former Member]

Hi Udi,

thanks a lot. The senario is quite easy. You have 2 table. The first with 3 column : A, B and C and the second with 3 Column A, B and D. The Column A and B form both table are the same with the same content. I need to have a new table with the column A, B, C, D with merge Column A and B.

Thanks in Advance

Regards,

Valérie

[former_member202465]

Hi Valérie,

This sounds like you need something like the following example:

Table 1:

a	b	c
a1	b1	c1
a2	b2	c2
a3	b3	c3
a4	b4	c4

Table 2:

a	b	d
a1	b1	d1
a2	b2	d2
a3	b3	d3
a4	b4	d4

Merged table:

a	b	c	d
a1	b1	c1	d1
a2	b2	c2	d2
a3	b3	c3	d3
a4	b4	c4	d4

In other words, it's like an SQL JOIN operation. Unfortunately, there is no operator to match it. A possible resolution could be to use a data service that does the SQL JOIN and returns the merged data.

Note that the JOIN operation could be done in on the database level or in Java code. For the latest, performance might be an issue and best be considered.

Thanks,

Udi