Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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