Skip to Content
avatar image
Former Member

Combine Operator in VC 7.3

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 26, 2013 at 05:36 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Valérie,

      This sounds like you need something like the following example:

      Table 1:

      a

      b

      ca1b1c1a2b2c2a3b3c3a4b4c4

      Table 2:

      a

      b

      da1b1d1a2b2d2a3b3d3a4b4d4

        

      Merged table:

      a

      b

      cda1b1c1d1a2b2c2d2a3b3c3d3a4b4c4d4

      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