topic Re: GROUP BY STATEMENT in QlikView

GROUP BY STATEMENT

Tue, 08 Apr 2014 07:47:05 GMT

is group by function possible with SQL select statement used while loading the data if yes please help me with the syntax for the same

Thanking You

Vinayagam .

Tue, 08 Apr 2014 07:55:52 GMT

[JSTO]: // Status object information

Load

[OBJNR] as [OBJNR],

[STSMA] as [STSMA],

[OBTYP] as [OBTYP];

SQL Select MAX(OBJNR) as OBJNR STSMA OBTYP from JSTO

GROUP BY STSMA OBTYP

;

STORE * FROM [JSTO] INTO JSTO.QVD;

DROP TABLE [JSTO];

MK_QSL — Tue, 08 Apr 2014 08:06:21 GMT

==========================

OLEDB CONNECT32 TO .......

Load

Supplier,

SUM(Quantity) as TotalQty,

SUM(Amount) as TotalAmount

Group By Supplier;

LOAD

Supplier,

Quantity,

Amount;

SQL SELECT *

FROM ABC.dbo."TableName";

==============================

Hope this help...