resident issue

[#1]

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.

[#2 · Accepted solution]

Hi,

Try with this:

Result:

Load ArrivalDates Resident Table1;

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

Regards,

Ricardo

[#3]

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