Adding a Sequential numbers Column

[#1]

Hi all,

I have a simple excel sheet loaded by the following code:

load
Name, Address
from [.\Names.xls]
(biff, embedded labels, table is Sheet1$);

I'd like to add a column which is an auto generated sequential number.

Table in Excel:
Name Address
Simon City1
Peter City2
Farah City3

Required Table in QlikView:
RrdID Name Address
1 Simon City1
2 Peter City2
3 Farah City3

[#2]

Apologies for being cheeky, but why not add this number in Excel?

[#3]

Because actually data sources are from multiple files joined into one table in Qlikview. I just wanted to make my question simple and clear.

[disqr_rm · Accepted solution]

Use RowNo() function in your chart expression and drag it to make it first column in your chart (if it has to be first column).

If you have subtotals in your chart, you may have to use RowNo(Total). Just play with it and you would know.

Hope this helps.

[#5]

Thanks Rakesh for your answer.

But actually, I want the numbers in the table-level, if possible.

[disqr_rm]

oh! I misunderstood. Try this:

load

RecNo() as RecordNumber, Name, Address

from [.\Names.xls]

(biff, embedded labels, table is Sheet1$);

[#7]

Unluckily it didn't work.

Following is what I tried and got:

Code:
T2:
LOAD RecNo() RID,
CUST_ID as CUST_ID,
CUST_NAME as CUST_NAME2
FROM

(biff, embedded labels, table is CUSTS2$);

Error Returned:
Syntax error, missing/misplaced FROM:
T2:
LOAD RecNo() RID,
CUST_ID as CUST_ID,
CUST_NAME as CUST_NAME2
FROM

(biff, embedded labels, table is CUSTS2$)

[llauses243]

is ...

T2:
LOAD RecNo() RID,

must be ..

T2:
LOAD RecNo() as RID,

llauses@llauses.com

[#9]

yes you are right.