Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlicker,
How to I write the code in the script for Where Clause and Group by for single table...
i'm writing the script like
Load
EmpId ,
SeqNo
From
Table location;
From this I want to get the max seqNo
Thanks in advance..
Load EmpID, FirstSortedvalue([Serial No],-[Serial No]) As [Serial No], FirstSortedValue([Level Code],-[Serial No]) As[Level Code] group by EmpID;
Load
EmpID,
[Serial No],
[Level Code]
FROM
(
It´s worked? Why you need another way?
Thanks buddy........