Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
first 10
load *
from tablename;
Interesting solution but I need more a solution which I can use with "if".
Like:
If (line>10, number=5, number) as number
ur question is not clear can u clarify what do u want.
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.
Thanks Jagan, that is what I wanted.