Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There
I have two tables and require the output of the table 3
How can I join this? I have tried outer join doesn't seem to work...
Table 1 | |
Field 1 | Field2 |
Value1 | Field2Value1 |
Value2 | Field2Value2 |
Value3 | Field2Value3 |
Table2 |
Field2 |
Field2Value1 |
Field2Value2 |
Field2Value3 |
Field2Value4 |
Field2Value5 |
Field2Value6 |
Required Output | |
Table 3 | |
Field 1 | Field2 |
Value1 | Field2Value1 |
Value1 | Field2Value2 |
Value1 | Field2Value3 |
Value1 | Field2Value4 |
Value1 | Field2Value5 |
Value1 | Field2Value6 |
Value2 | Field2Value1 |
Value2 | Field2Value2 |
Value2 | Field2Value3 |
Value2 | Field2Value4 |
Value2 | Field2Value5 |
Value2 | Field2Value6 |
Value3 | Field2Value1 |
Value3 | Field2Value2 |
Value3 | Field2Value3 |
Value3 | Field2Value4 |
Value3 | Field2Value5 |
Value3 | Field2Value6 |
Value4 | Field2Value1 |
Value4 | Field2Value2 |
Value4 | Field2Value3 |
Value4 | Field2Value4 |
Value4 | Field2Value5 |
Value4 | Field2Value6 |
Value5 | Field2Value1 |
Value5 | Field2Value2 |
Value5 | Field2Value3 |
Value5 | Field2Value4 |
Value5 | Field2Value5 |
Value5 | Field2Value6 |
Value6 | Field2Value1 |
Value6 | Field2Value2 |
Value6 | Field2Value3 |
Value6 | Field2Value4 |
Value6 | Field2Value5 |
Value6 | Field2Value6 |
Hi,
Try this:
Table1:
LOAD
Field1
From location;
outer join (Table1)
LOAD
Field2
From location2;
By skipping the Field2 on the first table you don't have any keys that match, which will cause the expected result.
Hi,
Try this:
Table1:
LOAD
Field1
From location;
outer join (Table1)
LOAD
Field2
From location2;
By skipping the Field2 on the first table you don't have any keys that match, which will cause the expected result.