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.
Load *, right(Field1,4) as Field2
where exists(Field2, right(Field1,4));
That worked great!
Retrieving data ...