Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

inhaus-bolivia
New Contributor

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
MVP & Luminary
MVP & Luminary

Re: I need some help odbc scrpit

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