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: 
upaliwije
Creator II
Creator II

Restrict Load

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

1 Solution

Accepted Solutions
its_anandrjs

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

View solution in original post

9 Replies
ashfaq_haseeb
Champion III
Champion III

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

upaliwije
Creator II
Creator II
Author

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

Like

set Flag=Y

then use that variable to restrict laod

ashfaq_haseeb
Champion III
Champion III

Ok,

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

Explain properly.

Regards

ASHFAQ

upaliwije
Creator II
Creator II
Author

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

ashfaq_haseeb
Champion III
Champion III

Hi,

Can you explain what are yo trying to achieve here?

Regards

ASHFAQ

upaliwije
Creator II
Creator II
Author

Hi

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

ashfaq_haseeb
Champion III
Champion III

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

its_anandrjs

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

upaliwije
Creator II
Creator II
Author

Thanks both of you