MAX Date

[dseelam]

hello all,

I don't know how to put this in to question, please check the attachments first

results needed in QVW - I want to see only one A in the column test with max date as 1/2/2017

thanks,

D

[sunny_talwar]

Try this:

test:

LOAD test,

[receipt date],

sales

FROM

[TEST*.xlsx]

(ooxml, embedded labels, table is Sheet1);

Right Join (test)

load test,

  Max([receipt date]) as [receipt date]

Resident test

Group By test;

[dseelam]

Sunny, thanks you for the reply

I just want to see max date on front end view, I don't want to avoid data coming in to data model bcoz I need history

[sunny_talwar · Accepted solution]

Then use a left join with a flag

test:

LOAD test,

[receipt date],

sales

FROM

[TEST*.xlsx]

(ooxml, embedded labels, table is Sheet1);

Left Join (test)

load test,

  Max([receipt date]) as [receipt date],

  1 as Flag

Resident test

Group By test;

Now use the flag to restrict seeing the latest test value