Incremental Load with Time stamp

vikasmahajan — Fri, 27 Mar 2015 09:19:53 GMT

Dear all,

I have following script I want to implement incremental load with timestamp filed , Please can any one guide me how to implement the same.

Thanks in adv

Vikas

GLENTRY:

LOAD timestamp,

[Entry No_],

[G_L Account No_],

[Posting Date],

[Document Type],

[Document No_],

Description,

[Bal_ Account No_],

Amount,

[Global Dimension 1 Code],

[Global Dimension 2 Code],

[User ID],

[Source Code],

[System-Created Entry],

[Prior-Year Entry],

[Job No_],

Quantity,

[VAT Amount],

[Business Unit Code],

[Journal Batch Name],

[Reason Code],

[Gen_ Posting Type],

[Gen_ Bus_ Posting Group],

[Gen_ Prod_ Posting Group],

[Bal_ Account Type],

[Transaction No_],

[Debit Amount],

[Credit Amount],

[Document Date],

[External Document No_],

[Source Type],

[Source No_],

[No_ Series],

[Tax Area Code],

[Tax Liable],

[Tax Group Code],

[Use Tax],

[VAT Bus_ Posting Group],

[VAT Prod_ Posting Group],

[Additional-Currency Amount],

[Add_-Currency Debit Amount],

[Add_-Currency Credit Amount],

[Close Income Statement Dim_ ID],

[IC Partner Code],

Reversed,

[Reversed by Entry No_],

[Reversed Entry No_],

[Dimension Set ID],

[Prod_ Order No_],

[FA Entry Type],

[FA Entry No_],

[Tax Amount],

[Location Code],

[Vendor Bill Date],

[Vendor Bill Amount],

[Payee Name],

[P_O_ No_]

FROM

[..\Qvds\NAVQVDS\GL_QVD.qvd]

(qvd);

Re: Incremental Load with Time stamp

Ralf-Narfeldt — Fri, 27 Mar 2015 09:35:44 GMT

If you check out the section Using QVD Files for Incremental Load

in the QlikView Help or Reference manual, there are examples for the different incremental load use cases (append, update, edit, delete)

topic Incremental Load with Time stamp in QlikView

Incremental Load with Time stamp

Re: Incremental Load with Time stamp