Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
raghuvr33
Contributor III
Contributor III

Execution of script failed. Reload old data ??

Get this error when trying to load multiple years data from QVD. Have ensured only one column unique between tables and it creates Syn Keys.

Script is

LOAD %AccountKey,
     Account_Active_,
     Account_Code,
     [Account Description]
FROM

(qvd);

LOAD %CCKey,
     CostCenter_Active_,
     Cost_Center,
     [Cost Center Description]
FROM

(qvd);

LOAD %CustomerKey,
     Customer,
     Bill_TO,
     [customer class],
     [Credit Hold],
     [Credit Limit],
     [Credit Terms],
     [Customer Region],
     [Customer Remarks],
     Cust_Site,
     Sales_person,
     Taxable,
     [Customer Type]
FROM

(qvd);

LOAD %EntityKey,
     Entity_,
     Entity_Description
FROM

(qvd);

LOAD [Location Name],
     [GL Account Code],
     %AccountKey,
     [Transaction Amount],
     %CCKey,
     [Transaction Description],
     [GL Document],
     [GL Document Type],
     [GL Effective Date],
     [Invoice Month],
     [Invoice Year],
     %EntityKey,
     [GL Transaction Line],
     [GL Project Code],
     [GL Reference],
     %SubAccountKey,
     [GL Transaction Type]
FROM

(qvd);

LOAD [Location Name],
     %AccountKey,
     %CCKey,
     [Invoice Comment Index],
     [Invoice Comment],
     [Invoice Discount Percentage],
     [Invoice Discount Account],
     [Invoice Discount Project],
     [Invoice Discount SubAccount],
     [Invoice Due Date],
     Invoice_Number,
     [Invoice Line],
     [Invoice Sales Order],
     %ItemKey,
     [Invoice Partial OK],
     [Invoice Performance Date],
     [Invoice Pick Date],
     [Invoice Unit Price],
     [Invoice Product Line],
     %ProdLineKey,
     [Invoice Project Code],
     [Invoice Promise Date],
     [Invoice Quantity Invoiced],
     [Invoice Quantity Ordered],
     [Invoice Quantity Pending],
     [Invoice Performance Qty],
     [Invoice Quantity Pick],
     [Invoice Quantity Quoted],
     [Invoice Quantity Shipped],
     [Invoice Request Date],
     [Invoice Serial Number],
     [Invoice Ship To],
     %SiteKey,
     %SalespersonKey,
     [Invoice Status],
     %SubAccountKey,
     [Invoice Line Taxable],
     [Invoice Line Type],
     [Invoice Line Unit Of Measure]
FROM

(qvd);

LOAD [Location Name],
     %AccountKey,
     %CCKey,
     [Invoice Comment Index],
     [Invoice Comment],
     [Invoice Discount Percentage],
     [Invoice Discount Account],
     [Invoice Discount Project],
     [Invoice Discount SubAccount],
     [Invoice Due Date],
     Invoice_Number,
     [Invoice Line],
     [Invoice Sales Order],
     %ItemKey,
     [Invoice Partial OK],
     [Invoice Performance Date],
     [Invoice Pick Date],
     [Invoice Unit Price],
     [Invoice Product Line],
     %ProdLineKey,
     [Invoice Project Code],
     [Invoice Promise Date],
     [Invoice Quantity Invoiced],
     [Invoice Quantity Ordered],
     [Invoice Quantity Pending],
     [Invoice Performance Qty],
     [Invoice Quantity Pick],
     [Invoice Quantity Quoted],
     [Invoice Quantity Shipped],
     [Invoice Request Date],
     [Invoice Serial Number],
     [Invoice Ship To],
     %SiteKey,
     %SalespersonKey,
     [Invoice Status],
     %SubAccountKey,
     [Invoice Line Taxable],
     [Invoice Line Type],
     [Invoice Line Unit Of Measure]
FROM

(qvd);

LOAD [Location Name],
     [Invoice Bill To],
     [Invoice Header Channel],
     [Invoice Header Comment Index],
     [Invoice Header Credit Terms],
     %CustomerKey,
     [Invoice Header Due Date],
     [Invoice Date],
     [Invoice Month],
     [Invoice Year],
     Invoice_Number,
     [Invoice Header Sales Order],
     [Invoice Header Ordered Date],
     [Invoice Header Partial OK],
     [Invoice Header Purchase Order],
     [Invoice Header Project Code],
     [Invoice Header Sales Quote],
     [Invoice Header Request Date],
     [Invoice Header Remarks],
     [Invoice Header Ship Date],
     %SiteKey,
     %SalespersonKey,
     [Invoice Taxable],
     [Invoice Trailer1 Amount],
     [Invoice Trailer1],
     [Invoice Trailer2 Amount],
     [Invoice Trailer2],
     [Invoice Trailer3 Amount],
     [Invoice Trailer3],
     [Invoice Type]
FROM

(qvd);

LOAD %ItemKey,
     [ABC Code],
     [BOM Code],
     [Item Description1],
     [Item Description2],
     [Item Group],
     Item_,
     [Item Type],
     [Item Price],
     Item_Product_Line,
     [Item Site_],
     [Item Status],
     [Item Unit Of Measure]
FROM

(qvd);

LOAD %ProdLineKey,
      Product_Line,
     [ProductLine Description]
FROM

(qvd);

LOAD [Location Name],
     %AccountKey,
     %CCKey,
     [Sales Detail Comment Index],
     [Sales Detail Comment],
     [Sales Detail Confirmed],
     [Sales Detail Item Description],
     [Sales Detail Discount Account],
     [Sales Detail Discount CostCenter],
     [Sales Detail Discount Project],
     [Sales Detail Discount SubAccount],
     [Sales Detail Due Date],
     [Sales Detail Expire Date],
     [Sales Detail Invoice Number],
     [Sales Detail Order Line],
     [Sales Detail List Price],
     [Sales Detail Modified Date],
     Sales_Order,
     %ItemKey,
     [Sales Detail Partial],
     [Sales Detail Performance Date],
     [Sales Detail Pick date],
     [SOD Price List],
     [Sales Detail Unit Price],
     [Sales Detail Product_Line],
     %ProdLineKey,
     [Sales Detail Project_Code],
     [Sales Detail Promise Date],
     [Sales Detail Qty Allocated],
     [Sales Detail Qty To Ship],
     [Sales Detail Qty Invoiced],
     [Sales Detail Qty Ordered],
     [Sales Detail Qty Shipped],
     [Sales Detail Ship To],
     %SiteKey,
     %SalesPersonKey,
     [Sales Detail Cost],
     %SubAccountKey,
     [Sales Detail Ship Type],
     [Sales Unit Of Measure],
     [Sales Detail Ext Price]
FROM

(qvd);

LOAD [Location Name],
     [Sales Order Bill TO],
     [Sales Order Channel],
     [Sales Head Comment Index],
     %CustomerKey,
     [Sales Order Due Date],
     [Sales Order Invoice Date],
     [Sales Order Invoice Number],
     [Sales Order Invoiced],
     Sales_Order,
     [Sales Order Order date],
     [Order Year],
     [Order Month],
     [Sales Order Partial OK],
     [SO Purchase Order],
     [SO Price List],
     [Sales Order Project],
     [Sales Quote],
     [Sales Order Request Date],
     [Sales Order Revision],
     [Sales Order Remarks],
     [Sales Header Ship To],
     [Sales Order Ship Date],
     %SiteKey,
     %SalesPersonKey,
     [Sales Trailer 1],
     [Sales Trailer 1 Amount],
     [Sales Trailer 2 Amount],
     [Sales Trailer 2],
     [Sales Trailer 3 Amount],
     [Sales Trailer 3],
     Type
FROM

(qvd);

LOAD %SalesPersonKey,
     Sales_Person,
     [Sales Person Name]
FROM

(qvd);

LOAD %SiteKey,
     [Site Description],
     Site_
FROM

(qvd);

LOAD %SubAccountKey,
     [Sub_Account Description],
     Sub_Account
FROM

(qvd);

Appreciate any input on what is wrong with the above script

0 Replies