topic Re: Restrict Load in QlikView

Restrict Load

upaliwije — Sun, 19 Oct 2014 12:14:04 GMT

I have following script for creating a QVD file

VEH_TYPE:

//FIRST 1000

Load POLICY_NO,VEH_TYPE;

SELECT pol_policy_no POLICY_NO, pol_prs_type, pol_prs_type_desc VEH_TYPE

FROM cicl.mv_uw_vtype_info;

store VEH_TYPE into e:\qlikview\Qvd\FACT_table\VEH_TYPE.qvd;

Trace

drop table VEH_TYPE;

I want to restrict the load of this script by applying a condition say if flag=Y

How can I do it please

Re: Restrict Load

ashfaq_haseeb — Sun, 19 Oct 2014 12:24:17 GMT

Hi,

Try like this

VEH_TYPE:

//FIRST 1000

Load POLICY_NO,VEH_TYPE;

SELECT pol_policy_no POLICY_NO, pol_prs_type, pol_prs_type_desc VEH_TYPE

FROM cicl.mv_uw_vtype_info

where flag='Y';

Regards

ASHFAQ

Re: Restrict Load

upaliwije — Sun, 19 Oct 2014 12:30:20 GMT

This is not my requirement. There is no filed Called Flag in my source table. I want to create a variable called flag

set Flag=Y

then use that variable to restrict laod

Re: Restrict Load

ashfaq_haseeb — Sun, 19 Oct 2014 12:32:53 GMT

Ok,

For what condition you need to set Flag='Y'

Explain properly.

Regards

ASHFAQ

Re: Restrict Load

upaliwije — Sun, 19 Oct 2014 12:37:21 GMT

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

set flag=Y

If flag=Y

VEH_TYPE:

//FIRST 1000

Load POLICY_NO,VEH_TYPE;

SELECT pol_policy_no POLICY_NO, pol_prs_type, pol_prs_type_desc VEH_TYPE

FROM cicl.mv_uw_vtype_info;

store VEH_TYPE into e:\qlikview\Qvd\FACT_table\VEH_TYPE.qvd;

Trace

drop table VEH_TYPE

;

Can I add a condition like above given in Bold

Re: Restrict Load

ashfaq_haseeb — Sun, 19 Oct 2014 12:58:34 GMT

Hi,

Can you explain what are yo trying to achieve here?

Regards

ASHFAQ

Re: Restrict Load

upaliwije — Sun, 19 Oct 2014 13:08:06 GMT

What I am trying to achieve is to load this script as and when I want to do this. There are some more loading in the same file but I want this loading to be done once a month

Re: Re: Restrict Load

ashfaq_haseeb — Sun, 19 Oct 2014 13:13:37 GMT

Hi,

You can try something like this

SET flag='Y';

If (flag)='Y' then

load * Inline
[
Month
Jan
Feb
Mar
];

ENDIF 
 Trace 'Ashfaq'

Take a new file and try by changing value of flag to Y and N as required.

Regards

ASHFAQ

Re: Restrict Load

its_anandrjs — Sun, 19 Oct 2014 14:33:41 GMT

Dear Upali,

For your script check the below load script

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Let flag = 'Y';

If flag = 'Y' then

VEH_TYPE:

//FIRST 1000

Load POLICY_NO,VEH_TYPE;

SELECT pol_policy_no POLICY_NO, pol_prs_type, pol_prs_type_desc VEH_TYPE

FROM cicl.mv_uw_vtype_info;

Store VEH_TYPE into e:\qlikview\Qvd\FACT_table\VEH_TYPE.qvd;

Trace 'Script Run Successful'

Drop table VEH_TYPE;

END IF

Regards,

Anand

Re: Restrict Load

upaliwije — Sun, 19 Oct 2014 15:19:55 GMT

Thanks both of you