How to combine 2 tables ?

[Derek_T]

I chose the word "combine" because I don't think it's a join (no common Key).
I have two very simple tables and the expected results is in yellow.

is there an "elegant" way to do this using Script ? 

Thanks

[Or · Accepted solution]

Load * From Table1;

JOIN

Load * From Table2;

Should work here, I believe.

[Fernando_Fabregas]

Before the first load add NoConcatenate to generate another table...

[sidhiq91]

@Derek_T  I can the answer as you expected using below script. Please try and let us know.

NoConcatenate
Temp1:
Load * inline [
Data1
A,
B,
C
];

Join (Temp1)
Temp2:
Load * inline [
Data2
1,
2,
3
];

Exit Script;

[sidhiq91 · Accepted solution]

@Derek_T  You may even prefer Outer Join instead of just JOIN. Both produce the same result. See below for the code. When there is no common key to make a join, a simple JOIN prefix or Outer JOIN can be used to combine the tables.

NoConcatenate
Temp1:
Load * inline [
Data1
A,
B,
C
];

outer Join (Temp1)
Temp2:
Load * inline [
Data2
1,
2,
3
];

Exit Script;

[Derek_T]

Thanks, worked like charm. I did not expect an outer join to work with no common keys.
I though this would just create empty field in front of each table column.

[Or]

The "Outer" isn't necessary. A simple "Join" will provide the Cartesian of the two tables if they have no common fields (there's nothing to Outer join on with no matching fields). For clarity, I'd suggest avoiding the "Outer" part.