Why isn't my max date working

[D19PAL]

Hi,

Why is this not working?

Lib connect to *****;

Load

Regions,

Timestamp;

Test:

Select 

Regions,

Timestamp 

From "testdata";

Noconcatenate

Load

*,

Max(Timestamp) as test

Resident Test

Group by Regions;

I get invalid expressions 

[Or]

You're loading Timestamp (as part of '*') but it's not in the Group By expression, seemingly?

[D19PAL]

I tried it, still doesn't work.

Can you show it as a syntax example please.

Thanks 

[Or]

I can't, as you did not include sample data (or the error message you get).

[stevejoyce · Accepted solution]

Right, what @Or said.  your grouped by statement has Timestamp as a field but not part of the group by.  Assuming you don't want to group by Timestamp if you are aggregating by it.

Load

Regions,

Timestamp;

Test:

Select 

Regions,

Timestamp 

From "testdata";

Noconcatenate

Load

Regions,

Max(Timestamp) as test

Resident Test

Group by Regions;

[D19PAL]

Where I got group by Regions, does it need to be

Group by Timestamp, Regions;

The following error occurred:

Invalid expression