May be someone here can help to untwist my brain. I could not find a solution up to now.

I have 2 tables and want to get a cross join. Sample:

Data Feed 1 returns:

SQUARE    08  1234

CALC         08   5678

 

Data Feed 2 returns:

07

08

09

I want to construct the following output within a Data Feed:

SQUARE 07            0

SQUARE 08            1234

SQAURE 09           0

CALC     07            0

CALC     08           5678

CALC     08           0

I didn't manage to achieve this with the Combine or Concatenate operators. Any idea?

 or register to reply.

Notify Moderator