Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I need to deploy a sum function in my script. Does anyone have an idea why this is not working (see attached pic)? This is the error message: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Die QLIK ProBatch300 2009R2 DE DEV.dbo.DEVEL Pro Batch 3_00 DE$Bank Account Ledger Entry.Amount (LCY)-Spalte ist in der Auswahlliste ungültig, da sie nicht in einer Aggregatfunktion und nicht in der GROUP BY-Klausel enthalten ist. (THIS MEANS: Amount (LCY) is invalid, since it is not in an an aggregate function and not in the Group by clause.)
SQL SELECT "Bank Account No_", "Posting Date", "Amount (LCY)"
FROM "QLIK ProBatch300 2009R2 DE DEV".dbo."DEVEL Pro Batch 3_00 DE$Bank Account Ledger Entry"
GROUP by "Bank Account No_", "Posting Date". Thanks in advance! Michael
You are applying Group by on SQL Select . You need to do it at Load level.
Load
A,
B,
Sum(C)
Group By A,B ;
SQL Select A,B,C from........................
Hop this will Help You.
Regards
VIjay
Hi,
Try this
SQL SELECT "Bank Account No_", "Posting Date", Sum("Amount (LCY)")
FROM "QLIK ProBatch300 2009R2 DE DEV".dbo."DEVEL Pro Batch 3_00 DE$Bank Account Ledger Entry"
GROUP by "Bank Account No_", "Posting Date"
Regards,
Jagan.
You are applying Group by on SQL Select . You need to do it at Load level.
Load
A,
B,
Sum(C)
Group By A,B ;
SQL Select A,B,C from........................
Hop this will Help You.
Regards
VIjay
Perfect! Thanks so much!