How to get the record number in graphical CV

[former_member213277]

Hi Experts,

I have a requirement to populate the row number for the data set that comes out of the graphical CV

Assume that output of the CV will be as shown below

CompanyCode	GLAccount	FiscalYear	Measure1
US99	50008	2015	200
US99	60347	2015	140
US99	50347	2015	666
US99	81308	2015	200
US99	50008	2015	0

Now I want to populate the record number(RowID) against each row, as shown below

CompanyCode	GLAccount	FiscalYear	Measure1	RowID
US99	50008	2015	200	1
US99	60347	2015	140	2
US99	50347	2015	666	3
US99	81308	2015	200	4
US99	50008	2015	0	5

Can some one explain me how to get the row number for each of the record in graphical CV

Regards,

Nagaraj

[lbreddemann]

Just as more general remark, since you've already received technically correct ways to achieve your goal here:

Whenever the requirement is to generate "RowIDs" and not to rank records based on some criteria you should be very cautious.

Typically this is the first step to 'row-by-row' processing which means slow performance and very likely wrong processing in a parallel data access system.

These kind of "RowIDs" are not stable at all and don't serve to identify any specific row at all.

In short: generated RowIDs should be considered a "code-smell" that points to an anti-pattern.