Records

[#1]

Hi,

I have an excel shhet with two fields like S.NO(1-30 ) and NAME(A-Z and AA,AB,AC,AD) are the field values.

Now my requirement is like,  whenever i loaded this excel  into qlikview i don't want the records from 25 to 30.rest of the records will disply.

Please help in this.

Thanks&Regards,

CHIRUMAMILLA

[Anonymous]

Do you not want them loaded at all?

If that's the case you can just use a where clause at the end of your load statement, after the spreadsheet name.

In this case it would be

Where S.NO < 25;

[settu_periasamy]

Hi,

Try this (if you want only to delete 26 to 30 rows)

LOAD S.No,

     Name

FROM

[..\Yourfile.xlsx]

(ooxml, embedded labels, table is Sheet1, filters(

Remove(Row, RowCnd(Interval, Pos(Top, 27), Pos(Top, 30), Select(1, 0)))

));