topic Re: Where clause in preceding load in QlikView

Where clause in preceding load

Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I would like to find out if I can use the "Where" clause in preceding load statement to filter date?

Thanks

Re: Where clause in preceding load

Anil_Babu_Samineni — Fri, 10 Feb 2017 09:10:41 GMT

May be helpful

Preceding Load

Re: Where clause in preceding load

migueldelval — Fri, 10 Feb 2017 09:10:53 GMT

Hi Moses,

Could you explain a little bit your question?

I used a If condition to make it, buat y don´t know if it´s correct for you.

Regards

Miguel del Valle

Re: Where clause in preceding load

tresB — Fri, 10 Feb 2017 09:15:24 GMT

Yes you can. Do you face any issues?

Re: Where clause in preceding load

robert_mika — Fri, 10 Feb 2017 09:17:29 GMT

Definitely..

Re: Where clause in preceding load

surendraj — Fri, 10 Feb 2017 09:25:50 GMT

Yes...you can..

For your reference...

Tab1:

Load *,max(salary) as maxsal

where date='01/10/2017'

group by empname,Date;

Load empname,

Date,

salary

from----------(.txt);

Re: Where clause in preceding load

vikasmahajan — Fri, 10 Feb 2017 09:33:28 GMT

Refer this https://www.tutorialspoint.com/qlikview/qlikview_preceding_load.htm

use where condition in first block

Hope resolves

Vikas

Re: Where clause in preceding load

Fri, 10 Feb 2017 09:43:08 GMT

Ok, so what I am trying to achieve is to perform Incremental Load. Scenario below:

I have base QVD( Agentproductivity.qvd) and located in the folder, which has data for last 18 months and I have load new data for last 3 days everyday. So I have written a script like below

Temp1:
LOAD max(date(LastStatusUpdateDate,'M/D/YYYY h:mm:ss[.fff] TT')) as MaxLastUp
from $(vQVD)\AgentProductivity.qvd(qvd);

//Store the Maximum value of LaststatusUpdate in a variable.
LET MaxLastUp=Peek('MaxLastUp',-1);
drop Table Temp1;

ODBC CONNECT TO SQLSource;

Temp1:

LOAD
Reference,

LastStatusUpdateDate

where LastStatusUpdateDate> $(MaxLastUp);

SQL select
Reference,
datetime as LastStatusUpdateDate

from activity_lead al

where date(ai.datetime)>= DATE_SUB(NOW(),INTERVAL 3 DAY);

Re: Where clause in preceding load

Fri, 10 Feb 2017 10:26:02 GMT

Make it like this (Single QUOTES)

where LastStatusUpdateDate> '$(MaxLastUp)';

Re: Where clause in preceding load

cmsjamesgreen — Fri, 10 Feb 2017 11:20:13 GMT

Agree with vikasmahajan‌ here, you should put the $(MaxLastUp) variable in the where clause of the SQL query, otherwise you will still be extracting more records than you need, even if they are filtered out in the preceding load.

Re: Where clause in preceding load

sdmech81 — Fri, 10 Feb 2017 11:21:46 GMT

Hi,

Create a variable say: Vdate= so n so

Then

Load A,

B,Yourdate where Yourdate>=$(Vdate);

sql select * from so n so table;

Sachin

Re: Where clause in preceding load

Peter_Cammaert — Fri, 10 Feb 2017 11:28:19 GMT

Yes, you can. But that's often considered bad practice.

Be careful.