Access the first 10 lines of an table

[qlikconsultant]

I have to change an attribut in the first 10 lines of an table.

I looking for the right comand but i didn't found anything in the help or the handbook.

[khadeer]

first 10

load *

from tablename;

[qlikconsultant]

Interesting solution but I need more a solution which I can use with "if".

Like:

If (line>10, number=5, number) as number

[khadeer]

ur question is not clear can u clarify what do u want.

[jagan · Accepted solution]

HI,

If you are looking in script level then use RowNo(), it gives the current row no, based on that you can implement your logic.

Ex:

LOAD

*,

If(RowNo() <= 0, Logic1, Logic2) AS TempValue

FROM DataSource;

Regards,

Jagan.

[qlikconsultant]

Thanks Jagan, that is what I wanted.