Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;