Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am loading a Table1 with script Right(Field1,4) as Field2.
Now I want to load Table2 with script Right(Field1,4) as Field2 but only where Field2 exists in Table1 load.
Any suggestions?
Try:
Table1:
Load *, right(Field1,4) as Field2
from ...table1source...;
Table2:
Load *, right(Field1,4) as Field2
from ...table2source...
where exists(Field2, right(Field1,4));
Try:
Table1:
Load *, right(Field1,4) as Field2
from ...table1source...;
Table2:
Load *, right(Field1,4) as Field2
from ...table2source...
where exists(Field2, right(Field1,4));
Thanks Gysbert
That worked great!
Joe