Reload top 100 rows values of a field

[#1]

Hi,

In my current app's i am having a field "LensKey", this field contains 5482 rows values.

Now what i am trying is to reload top 100 rows values. How can i work on this ?

Tab1:

LOAD RowNo() as MK,

           ID,

           if(len(DefectName)>0, DefectName) as DefectName,

     LensKey,

     AngleTabPos,

     LensPosX,

     LensPosY

FROM

[..\..\LGUI\2_QvdGenerator\QVD\1Days.qvd]

(qvd) where LensKey = Top 100 ;

Thanks in advance.

[perumal_41]

Hi,

Tab1:

LOAD RowNo() as MK,

           ID,

           if(len(DefectName)>0, DefectName) as DefectName,

     LensKey,

     AngleTabPos,

     LensPosX,

     LensPosY

FROM

[..\..\LGUI\2_QvdGenerator\QVD\1Days.qvd]

(qvd)  ;

tab2:

Load * Resident Tab1 where RowNo()=100 order by LensKey

Drop table Tab1.

\\

Try this Script .

Regards

Perumal

[lalitinmbd]

Tab1:

LOAD Recno() as Record,

           ID,

           if(len(DefectName)>0, DefectName) as DefectName,

     LensKey,

     AngleTabPos,

     LensPosX,

     LensPosY

FROM

[..\..\LGUI\2_QvdGenerator\QVD\1Days.qvd]

(qvd) where RecNo()<=100 ;

[#4]

Hi Perumal,

I tried what you sent, but it is not fetching single line also.

Is there any other way.

Thanks in advance.

[#5]

Hi Lalit,

Lines which are fetching not based on Lenskey order, it should fetch based on the LensKey top 100 in ascending order.

And top 100 lenskey should display.

Thanks

[perumal_41]

Hi,

Please Upload Ur file .

Regards,

Perumal. A

[#7]

Hi Permual,

Please find the attached qvw and qvd files.

Thanks

[lalitinmbd]

PFA

Please let me know if this works.

[perumal_41]

Hi,

Please Check this application .Is use ful for u

Regards

Perumal A