Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
example:
load * inline
[field1,field2
A1,B1
A2,B2
A3,B3
];
now: I want to show a table box in the sheet like this:
the table box like this:
rownumber field1 field2
1,A2,B2
2,A3,B3
Mainly I want to add a number before each line as a line number, starting with 1?
tIf this is a StraightTableBox I think you can use the function RowNo() as expression and put it in front of your dimensions.
Not sure if this can be called in a TableBox though.
Thank you,[:'(],but i can only select table box,and i don't find how to set in the table box
You cannot add expressions (in version 9 at least -think of it as a listbox that shows more than one field) in a TableBox, since it lists the values for the fields you put on it. Moreover when this field is actually an expression, since you don't want to have the record number rather than the actual number of rows for the table. A straight table with field1 and field2 as dimensions and
RowNo(TOTAL)
as expression will do what you want.
Regards