topic Re: resident issue in QlikView

resident issue

Mon, 25 Mar 2013 14:57:45 GMT

Hi,

I have a problem that´s been driving me mad.

I want to load all possible arrival dates from Table1. Then from Table2 I want to

load alla Articles that has a date that exists in the ArrivalDate table...

I tried this:

Result:

Load ArrivalDates Resident Table1;

Load Articles, Date Resident Table2 Where exists(ArrivalDates)

Any help is appeciated

Thanks in advance.

Mon, 25 Mar 2013 15:01:45 GMT

Hi,

Try with this:

Result:

Load ArrivalDates Resident Table1;

Load Articles, Date Resident Table2 Where exists(ArrivalDates, Date);

Regards,

Ricardo

Mon, 25 Mar 2013 15:09:39 GMT

Hi,

Another way is:

Result:

Load ArrivalDates Resident Table1;

Left Join (Result)

Load Articles, Date as ArrivalDates Resident Table2;

Drop tables Table1, Table2;

Regards,

Neha