Restrict Load

[upaliwije]

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

[ashfaq_haseeb]

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]

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]

Ok,

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

Explain properly.

Regards

ASHFAQ

[upaliwije]

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]

Hi,

Can you explain what are yo trying to achieve here?

Regards

ASHFAQ

[upaliwije]

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]

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 · Accepted solution]

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]

Thanks both of you