Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pacoli2013
Creator
Creator

Data for my question about Max(LoadingDate)

Hello,

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

So here is some data and a script

Regards

Court

2 Replies
sunny_talwar

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
Creator
Creator
Author

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