Data Filter during Load

[#1]

Hi All,

I am struggling with the following senario, any help would be much appreciated.

I would like to filter visits that are loaded into Qlikview based on the VisitHubGoLiveDate

E.g. 

1. Only Load visits for site 1 where the VisitStartDate > = VisitHubGoLiveDate (VisitHubGoLiveDate = 01/01/2013)

2. Only Load visits for site 2 where the VisitStartDate > = VisitHubGoLiveDate (VisitHubGoLiveDate = 01/04/2013)

Visits:

Load         

          HubReference,

          VisitStartDate,

          ApplyMap('MAPTABLE',FIELD1)      AS VisitHubGoLiveDate

              ;

Select *

FROM dbase.Visits;

The two tables are joined based on the HubReference

Hub:

Load

     HubReference,

     GoLiveDate

;

Select *

FROM dbase.Hub;

Thanks

Martyn

[sujeetsingh]

You can use Where Exsists() function while load.

[#3]

I have attempted to add the wehere exists function but I am not sure If I am scripting it correctly

I have added the following to the script

SQL

SELECT *
FROM dbase.Visits (nolock)
where Exists (VisitStartDate > = VisitHubGoLiveDate);

Does this still work even if the Field VisitHubGoLiveDate is not part of the source table?