Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

I need some help odbc scrpit

I am trying to load this table with a new report

 

LIB CONNECT TO 'MS Access DB 2.0';

Nuevo:
LOAD "# of Days Late",
"# of Days to Ship",
BackOrder,
Cost,
"Customer Number",
"Date",
GrossSales,
"Invoice Date",
"Invoice Number",
"Item Desc",
"Item Number",
Margin,
"Open Qty",
OpenOrder,
"Order Number",
"Promised Delivery Date",
Sales,
"Sales Qty",
"Sales Rep Number",
SalesKey;
SQL SELECT "# of Days Late",
"# of Days to Ship",
BackOrder,
Cost,
"Customer Number",
"Date",
GrossSales,
"Invoice Date",
"Invoice Number",
"Item Desc",
"Item Number",
Margin,
"Open Qty",
OpenOrder,
"Order Number",
"Promised Delivery Date",
Sales,
"Sales Qty",
"Sales Rep Number",
SalesKey
FROM "C:\USERS\HP\DESKTOP\SCRIPT TUTORIAL\TUTORIALS SOURCE\Sales.accdb"."Sales data";


Tabla:
Load
[Item Desc],
Count([Item Desc]) as ordenclient
Resident Nuevo Group By [Item Desc];

 

Se ha producido el siguiente error:
Table 'Nuevo' not found
 
El error se ha producido aquí:
Load [Item Desc], Count([Item Desc]) as ordenitem Resident Nuevo Group By [Item Desc];
1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Make sure the data you load into Nuevo isn't automatically added to another table with the exact same fields. Use the NOCONATENATE keyword to prevent automatic concatenation

Nuevo:
NOCONCATENATE LOAD .... etc


talk is cheap, supply exceeds demand