Max function not working in the Where condition

[swathidumpala]

Hi Team ,

When I ran  the script with  ( where MKY='201907' ) condition it loaded well.

As part of automating the script when  I replaced the same 

with  num#(MKY) = max(num#(MKY)) I got an error while loading.

I am unsure why it is happening.

Requesting help!

Thanks,

Swati

[Anil_Babu_Samineni]

Perhaps this?

T1:
LOAD * From Inline;

MaxMKY:
LOAD Max(MKY) as MKY_Max Resident T1;

LET vMax = Peek('MKY_Max', -1, 'MaxMKY');

Final:
NoConcatenate
LOAD Id, MKY Resident T1 Where MKY = $(vMax);

DROP Table T1;