Apply a filter which affects two tables.

[CK_WAKE]

Hi There,

I have two tables, and unfortunately, I should not join them. However, I want to apply the conditions below.  In the model viewer i can see that table 1 and table 2 got  the connection using the ID as primary key.

I appreciate your help to achieve the below condition.

Tabe 1 got raised_date and the primary key is ID

Table 2  got survery_Date and the primary key is ID

and the condition i want is below  

WHERE (table1.raised_date> table2.survery_Date OR IsNull(table1.raised_date);

[Aasir]

I can suggest you to try below two ways, make sure you validate the data.

1. ApplyMap function to map the survery_Date from Table 2 to Table 1 based on the common ID field. Then apply the filter condition using the WHERE clause, comparing the raised_date from Table 1 with the survery_Date mapped from Table 2, and considering the case where raised_date is null.

2. Try one method two is a little walkaround method we'll talk about if method one fails. 😀