Can I combine Right function with Where Exists in load

[mazacini]

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?

[Gysbert_Wassenaar · Accepted solution]

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));

[mazacini]

Thanks Gysbert

That worked great!

Joe