5 Replies Latest reply: Feb 23, 2012 2:59 AM by Sokkorn Cheav RSS

    QVD File

    chris goudy

      I need to create QVD files for 3 separate data tables.

       

      I see that there are THREE ways to creat a QVD. 

       

      Are one of these easier then the others, or more standard?

      Would you recommend choosing a certain one?

        • QVD File
          Sokkorn Cheav

          Hi,

           

          For me the first one is better and simple.

          Ex: Store mytable into xyz.qvd (qvd);

           

          Regards,

          Sokkorn Cheav

            • QVD File
              chris goudy

              where would I place the statement in the script?

              Before or After the table I want to create a QVD with?

               

              eg.

               

              Store Member into xyz.qvd(qvd);

               

              Member:

              left keep (Transactions)//LEFT KEEP ... second table should be reduced to its common intersection with the first table before being stored in QlikView

              LOAD @1 as Status,

                         @2 as CardNo,

                         (num(@3)&'|'&@2) as %_MemberCardNoKey,

                         @3 as MemberNo, 

                         @4 as Surname,

                         @5 as Initials,

                         @6 as Title,

                          Capitalize(@7) as FirstName,

                         (Capitalize(@4)&' , '&Capitalize(@7)) as Fullname,

                         @8 as CashCustomerNo,

                         @9 as AccNo,

                         @10 as PHMProfileNo,

                         @11 as AddressLine1,

                         @12 as AddressLine2,

                         @13 as AddressLine3,

                         @14 as PostalCode,

                         @15 as DeliveryAddressLine1,

                         @16 as DeliveryAddressLine2,

                         @17 as DeliveryAddressLine3,

                         @18 as DeliveryPostalCode,

                         @19 as AcceptDate,

                         @20 as JoinDate,

                         @21 as FacilityDate,

                         @22 as ExpiryDate,

                         @23 as PinNo,

                         @24 as TelephoneNoHome,

                         @25 as TelephoneNoWork,

                         @26 as CellPhoneNo,

                         @27 as Email,

                         @28 as IDNo,

                         @29 as DateOfBirth,

                         Left(@29,4) as YearBorn,

                         (Year(Today())-Left(@29,4)) as MemberAge,

                         if(@30 = 'M','Male', If(@30 = 'F', 'Female','Unkown')) as Gender_Name,

                         if(@31 = 'A','Afrikaans', If(@31= 'E','English','Unknown'))as Language,

                         @32 as CardStatus,

                         @33 as MemberType,

                         @34 as UnderAgedChildren,

                         @35 as Occupation,

                         @36 as ScriptsHere,

                         @37 as AdditionalCards,

                         @38 as Exercise,

                         @39 as Notify,

                         @40 as CommunicationPreference,

                         '1'as Flag

                 

              FROM [C:\Users\Chris\TRAINING\Durbell Model\Data Directory\MEMBERDurbell.CSV]

              (txt, codepage is 1252, no labels, delimiter is ',', msq);

                • QVD File
                  Sokkorn Cheav

                  Hi,

                   

                  This must be after load statement.

                   

                  Member:

                  left keep (Transactions)//LEFT KEEP ... second table should be reduced to its common intersection with the first table before being stored in QlikView

                  LOAD @1 as Status,

                             @2 as CardNo,

                             (num(@3)&'|'&@2) as %_MemberCardNoKey,

                             @3 as MemberNo, 

                             @4 as Surname,

                             @5 as Initials,

                             @6 as Title,

                              Capitalize(@7) as FirstName,

                             (Capitalize(@4)&' , '&Capitalize(@7)) as Fullname,

                             @8 as CashCustomerNo,

                             @9 as AccNo,

                             @10 as PHMProfileNo,

                             @11 as AddressLine1,

                             @12 as AddressLine2,

                             @13 as AddressLine3,

                             @14 as PostalCode,

                             @15 as DeliveryAddressLine1,

                             @16 as DeliveryAddressLine2,

                             @17 as DeliveryAddressLine3,

                             @18 as DeliveryPostalCode,

                             @19 as AcceptDate,

                             @20 as JoinDate,

                             @21 as FacilityDate,

                             @22 as ExpiryDate,

                             @23 as PinNo,

                             @24 as TelephoneNoHome,

                             @25 as TelephoneNoWork,

                             @26 as CellPhoneNo,

                             @27 as Email,

                             @28 as IDNo,

                             @29 as DateOfBirth,

                             Left(@29,4) as YearBorn,

                             (Year(Today())-Left(@29,4)) as MemberAge,

                             if(@30 = 'M','Male', If(@30 = 'F', 'Female','Unkown')) as Gender_Name,

                             if(@31 = 'A','Afrikaans', If(@31= 'E','English','Unknown'))as Language,

                             @32 as CardStatus,

                             @33 as MemberType,

                             @34 as UnderAgedChildren,

                             @35 as Occupation,

                             @36 as ScriptsHere,

                             @37 as AdditionalCards,

                             @38 as Exercise,

                             @39 as Notify,

                             @40 as CommunicationPreference,

                             '1'as Flag

                     

                  FROM [C:\Users\Chris\TRAINING\Durbell Model\Data Directory\MEMBERDurbell.CSV]

                  (txt, codepage is 1252, no labels, delimiter is ',', msq);

                   

                  Store Member into Member.qvd;

                   

                  Regards,

                  Sokkorn Cheav