9 Replies Latest reply: Oct 19, 2014 11:19 AM by UPALI WIJERATNE RSS

    Restrict Load

    UPALI WIJERATNE

      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