topic Data for my question about Max(LoadingDate) in QlikView

Data for my question about Max(LoadingDate)

pacoli2013 — Wed, 18 Jan 2017 12:53:30 GMT

Hello,

I cannot add DataFiles to my first question about Max(LaadingDate)

So here is some data and a script

Regards

Court

sunny_talwar — Wed, 18 Jan 2017 13:12:08 GMT

You were having LoadingDate in your Group By statement.... Try this

LOAD

Company,

DataLevel,

Max(LoadingDate) as LoadingDate,

SalesOrderNumber,

Description,

SalesOrderStatusCode,

SalesOrderTypeCode,

LatestConfirmationDate,

DWHReportingCompCurrencyExchangeRateToCompCurrency

FROM [TrnDat_SalesOrderHdr.qvd] (qvd)

Group By Company, DataLevel, SalesOrderNumber, Description, SalesOrderStatusCode,

SalesOrderTypeCode, LatestConfirmationDate, DWHReportingCompCurrencyExchangeRateToCompCurrency;

pacoli2013 — Wed, 18 Jan 2017 13:34:26 GMT

Thanks Sunny,

So simply, why did't I figure it out by myself.

Perhaps I'm working too long at the same Document and become blind for such little things.

Regards

Court