serial number showing

[ajaykumar1]

Hi All,

How to arrange the serial number in a straight/Pivot table.

e.g.

Sr no  Custid  sal         Loc

  1          101     500      India

  2          201    1800   singapore

  3          302     9000     Malysia

  4          809    10000    US

Note : I don't have the sr no filed.  Its fine if it is not showing the text sr no in the table and atleast we have to show the numbers.

Thanks,

Ajay Kumar

[Anonymous]

Ajay

If your requirement is to generate a Serial Number in your load script when you do not have it in the source data, then I reckon you are in need of the Row() function.

Try using a line like this in your script load statement:

     RowNo() as [Serial Number]

Best Regards,     Bill

[Clever_Anjos]

You can add an expression = rowno(total)  to your table