Generating QVd based on previously created QVD

[deepakqlikview_123]

Hello Team,

Please find below data,

Dealer2:

LOAD DealerID,

     DealerInvoiceID,

     DealerInvoiceCode,

     OutletID,

     SerialNumber,

     PurchaseOrderID,

     VehicleID,

     SubModelTypeID,

     SubModelID,

     DealerInvoiceDate,

     ChassisNumber,

     DeliveryID,

     EngineNumber,

     ColorID,

     FinancerID,

     TaxRelationShipID,

     CustomerPurchaseOrderNumber,

     IsDelivered,

     IsDocsOK,

     IsActive,

     UnitPrice,

     BasicAmount,

     TypeOfCustomer,

     PaymentDetails,

     TypeOfInvoice,

     CustomerID,

     IsCancelled,

     IsDeleted,

     CreatedBy,

     CreatedOn,

     UpdatedBy,

     UpdatedOn,

     IsMigratedData,

     IsIDMSMigratedData

FROM

E:\Piaggio\Distribution\Increamental\Data\VES_DealerInvoice.qvd

(qvd);

Now I would loke to generate ther QVD  WHERE YEAR(DealerInvoiceDate) = 2014;

Can you please suggest hoe to do that.

Thanks

[ashfaq_haseeb · Accepted solution]

Hi may be like this.

LOAD DealerID,

     DealerInvoiceID,

     DealerInvoiceCode,

     OutletID,

     SerialNumber,

     PurchaseOrderID,

     VehicleID,

     SubModelTypeID,

     SubModelID,

     DealerInvoiceDate,

     ChassisNumber,

     DeliveryID,

     EngineNumber,

     ColorID,

     FinancerID,

     TaxRelationShipID,

     CustomerPurchaseOrderNumber,

     IsDelivered,

     IsDocsOK,

     IsActive,

     UnitPrice,

     BasicAmount,

     TypeOfCustomer,

     PaymentDetails,

     TypeOfInvoice,

     CustomerID,

     IsCancelled,

     IsDeleted,

     CreatedBy,

     CreatedOn,

     UpdatedBy,

     UpdatedOn,

     IsMigratedData,

     IsIDMSMigratedData

FROM

E:\Piaggio\Distribution\Increamental\Data\VES_DealerInvoice.qvd

(qvd)where Year(DealerInvoiceDate) = 2014;

Regards

ASHFAQ

[jonathandienst]

Hi

Data:

LOAD * FROM E:\Piaggio\Distribution\Increamental\Data\VES_DealerInvoice.qvd

WHERE YEAR(DealerInvoiceDate) = 2014 (qvd);

STORE Data into E:\Piaggio\Distribution\Increamental\Data\VES_DealerInvoice_2014.qvd (qvd);

HTH

Jonathan