Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to only import data where the date is less than that in another table?

Hi

I have a question.

I have one table called SurveyData that has columns:

Customer ID, Survey Response, Survey Date

another table called Complaints

Customer ID, Complaint Detail, Complaint Date

I only want to load complaint data for each Customer ID where the Complaint Date is less than or equal to the Survey date for each customer.

i.e i do not care about complaints that happen after the survey date

i tried after the

FROM [.....]

Where [Complaint Date] <= [Survey Date]

but errored.

any ideas?

thanks in advance!

0 Replies