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);
Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
