Solution: (Conditional Join)
Link Table 1 (Key1) to Table 2 (Key1) if they exist
Else link Table 1 (Key2) to Table 2 (Key2)
How do i approach this solution, and build the linking key ?
Any help is appreciated.
Can still a fragment of the original data and what do you want to get at the output?
Maybe try something like this:
Load if(len(Key1)>0,Key1,Key2) as Key, Key1 as T1.Key1, Key2 as T1.Key2, Field
Load if(len(Key1)>0,Key1,Key2) as Key, Key1 as T2.Key1, Key2 as T2.Key2, Field
Hope that helps,
May be something like this :
load * Inline [
Left Join (A)
B.ID1 as A.ID1,
B.ID2 as A.ID2,
Drop Table B;
Retrieving data ...