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?