Where clause and group by in single table

[Anonymous]

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..

[anbu1984]

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

(ooxml, embedded labels, table is Sheet1)

[Clever_Anjos]

It´s worked? Why you need another way?

[Anonymous]

Thanks buddy........