topic Problem with this function in QlikView

Problem with this function

ecabanas — Mon, 29 Oct 2012 09:37:17 GMT

I have Two tables:

COSTES cames from an excel and has the standard product costs

SALESLINE: is a sql table, and I want to introduce the value COSTEUDCASTD from table "costes" , I tryed this, but it doesn'y work...

Thank's in advance to eveyone!!!

Eduard

COSTES:

Directory;

LOAD [Código artículo] AS ITEMID,

[Descripcion Articulo],

[Precio Coste Ud] AS COSTEUDSTD,

[Precio Coste UD CA]AS COSTEUDCASTD

FROM

[..\..\..\Data BI\Costes_Standard.xlsx]

(ooxml, embedded labels, header is 10 lines, table is Cost);

SALESLINE:

Load SALESID, ITEMID, SALESSTATUS, NAME, QTYORDERED, SALESPRICE, INVENTTRANSID, CUSTACCOUNT,EVE_AMOUNTMSTEXCLTAX, year(CREATEDDATETIME)AS ANO, Month(CREATEDDATETIME)AS Mes;

SQL SELECT SALESID,ITEMID,SALESSTATUS,NAME,QTYORDERED,SALESPRICE,INVENTTRANSID,CUSTACCOUNT,CREATEDDATETIME,EVE_AMOUNTMSTEXCLTAX

from DynamicsAx.dbo.SALESLINE;

inner JOIN (SALESLINE)

LOAD ITEMID, COSTEUDCASTD

From COSTES;

Re: Problem with this function

swuehl — Mon, 29 Oct 2012 09:41:58 GMT

COSTES is a resident table, so try

inner JOIN (SALESLINE)

LOAD ITEMID, COSTEUDCASTD

resident COSTES;

Re: Problem with this function

Gysbert_Wassenaar — Mon, 29 Oct 2012 09:44:20 GMT

This is probably causing the error:

inner JOIN (SALESLINE)

LOAD ITEMID, COSTEUDCASTD

From resident COSTES;

But when you load SALESLINE it will be joined on COSTES as both contain the field ITEMID. So you can leave it out all together.

Re: Problem with this function

ecabanas — Mon, 29 Oct 2012 09:46:36 GMT

Hi swuehl, thank's fro your answer, but doing your answer I had this message:

not possible to open the file'C:\Users\eduard\Documents\COSTES' The system could not find the file

inner JOIN (SALESLINE)

LOAD ITEMID, COSTEUDCASTD

From COSTES

any idea?

thank's

Re: Problem with this function

ecabanas — Mon, 29 Oct 2012 09:53:04 GMT

Hi Gysbert!!!

Thank YOU!!!!!!!!!!!!!!!!!!!!!!!