topic Re: Can I combine Right function with Where Exists in load in QlikView

Can I combine Right function with Where Exists in load

mazacini — Thu, 07 Feb 2013 14:49:30 GMT

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 — Thu, 07 Feb 2013 15:00:54 GMT

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 — Thu, 07 Feb 2013 20:40:00 GMT

Thanks Gysbert

That worked great!

Joe