Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here is the load statement
Table 1 :
Load
Col 1
Col 2
Col 3
Resident A
Left Join
Table 2 :
Load
Col 1
Col 4
Col 5
Resident B
Left Join
Table 3 :
Load
Col 1
Col 6
Col 7
Resident C
Left Join
Table 4:
Load
Col 3
Col 8
Col 9
Resident D;
This is my script , i want to make sure that Table 3 is joined based on Col 1 from Table 1 NOT Table 2 .. how do i make sure ?
And also based on structure above on what column Table 4 is joined ?
Hi Steve,
The script you have written will always take col1 from Table1.
However to answer your question, you can add table name after left join like below
Table1:
Load col1, col2, col3 resident TableA
Left join(Table1)
Load col1, col4, col5 resident TableB
Regards
Akshaya
Hi Steve,
At the time of joining use table name like below:
Table1:
..
..
Left join(Table1)
Table3:
..
..
Thanks,
Arvind Patil
Hi Steve, you can create a field to check with exist(), ie:
Table 1 :
Load
Col 1
Col 2
Col 3
Resident A;
Left Join
Table 2 :
Load
Col 1
Col 1 as chkCol1
Col 4
Col 5
Resident B;
Left Join
Table 3 :
Load
Col 1
Col 6
Col 7
Resident C
Where not exists(chkCol1, Col1);
DROP Field chkCol1;
Left Join
Table 4:
Load
Col 3
Col 8
Col 9
Resident D;
Hi,
Can you provide us some sample data?