Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Ok,
For what condition you need to set Flag='Y'
Explain properly.
Regards
ASHFAQ
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
Hi,
Can you explain what are yo trying to achieve here?
Regards
ASHFAQ
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
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
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
Thanks both of you