topic Re: How to combine 2 tables ? in App Development

How to combine 2 tables ?

Derek_T — Mon, 27 Jun 2022 20:07:23 GMT

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

Re: How to combine 2 tables ?

Or — Mon, 27 Jun 2022 20:57:11 GMT

Load * From Table1;

JOIN

Load * From Table2;

Should work here, I believe.

Re: How to combine 2 tables ?

Fernando_Fabregas — Mon, 27 Jun 2022 21:04:04 GMT

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

Re: How to combine 2 tables ?

sidhiq91 — Tue, 28 Jun 2022 03:32:59 GMT

@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;

Re: How to combine 2 tables ?

sidhiq91 — Tue, 28 Jun 2022 03:48:49 GMT

@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;

Re: How to combine 2 tables ?

Derek_T — Tue, 28 Jun 2022 13:31:01 GMT

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.

Re: How to combine 2 tables ?

Or — Tue, 28 Jun 2022 13:34:30 GMT

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.