Problem adding a table

ecabanas — Mon, 05 Nov 2012 16:36:35 GMT

Hi everyone,

Sorry, but now I'm blocked!!! I have a table called SALESID_TEMP, that select fields from two sources.

I want to add to this table (after the last record) another table/source EVE_CUSTINVOICETRANS

I have the following scrip, but for example

ITEMID	SALESID	EVE_AMOUNTMSTEXCLTAX	COSTAMOUNTPOSTED(EVE_CUSTINVOICETRANS)
1	PV00001	100
2	PV00001	200

PICKING	PV00001		20
PICKING	PV00001		25

The PICKING lines come from EVE_CUSTINVOICETRANS

SALESLINE_TEMP:

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

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

from DynamicsAx.dbo.SALESLINE;

inner join(SALESLINE_TEMP)

Load INVENTTRANSID, DATEFINANCIAL;

SQL SELECT INVENTTRANSID, DATEFINANCIAL

from DynamicsAx.dbo.INVENTTRANS;

Concatenate (SALESLINE_TEMP)

Load SALESID,COSTAMOUNTPOSTED;

SQL SELECT SALESID,COSTAMOUNTPOSTED

from DynamicsAx.dbo.EVE_CUSTINVOICETRANS;

Thank you!!!

Eduard

topic Problem adding a table in QlikView

Problem adding a table